Lana,
What you're describing is typical of a corrupt workbook. One way to get
around this is to try to open the file in Star Office, which apparently does
a better job of opening corrupted Excel files than Excel does. It is
availble for download, but I don't have the link handy.
The real solution to file corruption is to use backups on a regular basis,
so that you don't have to start from scratch each time. Any important file
should be saved on your local machine in at least two places - prefereably
on different physical disks - and on a network if you are attached to one.
EVERY working file of mine is stored in at least three places, and written
to CD on a regular basis.
HTH,
Bernie
MS Excel MVP
"Lana " wrote in message
...
Hi people
My Excel has become very slow: it takes up to 15-20mins to open. I
removed the Personal macros book from start-up and it is ok now.
I wonder what should I do? I need my macroses ;o((( Excel stops
working when I open Personal manually afterwards. And it's not that big
- nothing of the kind. Maybe 200 lines of code. That's it.
Has anybody experienced that before?
Thanks
---
Message posted from http://www.ExcelForum.com/