Strange Excel File Issue

[patrickBOOTH]

Nothing wonky at all. There is a summation of multiple tabs, but that's it. Not even a Vlookup. I mean it could just be the charts. I am going to redo it and if it happens again I know it is just the charts. I have 13 tabs with three charts in each tab. In my mind this shouldn't be taking up the space it is and causing all of the hiccups.

 

[patrickBOOTH]

When I try to repaste the data into a new workbook I get a message that says

"The range you are pasting contains formulas that cannot be pasted into this instance of Excel; however, the formulas will be pasted as values. This may result from pasting formulas from Protected View, another instance of Excel or from another application."

WTF?

 

[patrickBOOTH]

Copied and pasted data from each tab into a new workbook and ignored that stupid error. I recalculated all of the formulas because they were pasted as values. Old workbook size: 246MB, new workbook size: 10MB. So ******* weird. This one works fine now.

 

[gomestar]

when you deleted the rows/columns from earlier, how did you do it? Moving the tables and getting such a smaller file suggests noise separate from all of your data, and the file size suggests repeated noise (could have been on just one sheet).

 

[patrickBOOTH]

I did it the way you told me. All in all I think it was corrupted or something. Like I mentioned I had a tab that was being fed by a different workbook. I thought that was why it was very slow, especially due to it being on a server. I thought deleting that tab would fix it, but it didn't. I think it was just some sort of fluke.