C
Carl Sheldon
I have a problem. One spreadsheet has 10 tabs with each tab detailing
various bits of information, containing links and hidden columns etc. The
whole file is only 2Mb and works perfectly fine. I copied and pasted all
tabs separately (paste special formats, then paste special values) to a new
spreadsheet - note this only has values and formats in it has ballooned to
32 mb and keeps crashing my system. I have no links in the new sheet and I
cant understand what is taking up the memory when its simply and value file.
Can any of you Excel whizzo's help me out, I am going round in circles.
Cheers Carl
various bits of information, containing links and hidden columns etc. The
whole file is only 2Mb and works perfectly fine. I copied and pasted all
tabs separately (paste special formats, then paste special values) to a new
spreadsheet - note this only has values and formats in it has ballooned to
32 mb and keeps crashing my system. I have no links in the new sheet and I
cant understand what is taking up the memory when its simply and value file.
Can any of you Excel whizzo's help me out, I am going round in circles.
Cheers Carl