Hi all,
I have a large file I'm trying to make smaller. It is 68.6 MB. Not a ton of data; however, I have several pivots and graphs tied to the data. No formulas or vlookups in the data tabs.
So - I went through and took out some cute little macros and icons that take the user from point a to point b etc. Stuff that isn't really necessary but nice to have.
No change in file size.
I scratched my head and thought, hmm, I should have seen "some" difference. So I took out a couple of tabs containing pivots and graphs.
No change in file size.
Now I'm stumped. What's going on here? I know in other softwear I've worked with there is a "pack and reindex" option. I can't seem to find anything in excel's "help" that can lead me to an answer.
So - all you great excel gurus out there - can you take mercy on me and throw me an idea or two?
Thanks!
I have a large file I'm trying to make smaller. It is 68.6 MB. Not a ton of data; however, I have several pivots and graphs tied to the data. No formulas or vlookups in the data tabs.
So - I went through and took out some cute little macros and icons that take the user from point a to point b etc. Stuff that isn't really necessary but nice to have.
No change in file size.
I scratched my head and thought, hmm, I should have seen "some" difference. So I took out a couple of tabs containing pivots and graphs.
No change in file size.
Now I'm stumped. What's going on here? I know in other softwear I've worked with there is a "pack and reindex" option. I can't seem to find anything in excel's "help" that can lead me to an answer.
So - all you great excel gurus out there - can you take mercy on me and throw me an idea or two?
Thanks!