[RESOLVED] Excel 2010 consumes a lot of memory
hi gurus, i had this excel file which was converted from 2003 to 2010, by using file save as method.
the files consumes memory up of to 1.6GB.
I'm not able to print the file, because every time I print it is always a blank page.
Funny thing is, i tried to delete all the contents of the worksheet just to check whether it is some formula messing up with the file.
And I save it to a different workbook or a new file name.
The empty workbook still consumes a memory up of to 1.6GB.
Any ideas? I tried to scan the file with SEP, finds nothing.
Any help is greatly appreciated.
Please help guys, don't know what to do.
Re: Excel 2010 consumes a lot of memory
check if it has any code in VBA, hidden sheets etc, its obviously got something in it,
what was the original file for? what did it contain?
Re: Excel 2010 consumes a lot of memory
hey, thanks for the reply.
i had checked there were no VBA codes, no hidden WS.
I was suspecting that the file might have been corrupted during the conversion from 2003 to 2010.
Just used the file "save as" method and clicking on the 2010 format.
I tried the method on this link: http://office.microsoft.com/en-us/ex...001034656.aspx
saving the file as SYLK (Symbolic Link) and converting it back to normal excel file, it works fine.
I had actually scan the file before doing anything and found nothing, so it could be the conversion that have caused the messed up.