excel 2007 take toooo long to open the file

[tony567]

i have a file workz.xlsb which hard to open, it is only 4MB, but almost an hour to open by Excel.
It is only behave on this workz.xlsb!
My computer is 1GB ram, and 2GB processor

ok, now the position the file is opened
i save it with different file name, for example abc.xlsb
and then i save it again with different file name, cde.xlsb
and now from windows explorer i open abc.xlsb and you know what, its speed is normal when opening,

but not when i close all the workbook and i open it again... take tooo long to open, again!
i already delete all defined name and blank cell that maybe bloat.


anyone please tell me what is going on

thank you

 

[tony567]

thank you for your time guys,

i think i found it, it is because excel try to find the link source in another file/folder in different computer/network that finally it do not exist.

after i delete the formula linked to another source outside the file, it is fine now when i reopen it, normal speed in just a few second opening.

thank you