Perconal Macro Book sabotated Excel's work

L

Lana

Hi people

My Excel has become very slow: it takes up to 15-20mins to open.
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 stop
working when I open Personal manually afterwards. And it's not that bi
- nothing of the kind. Maybe 200 lines of code. That's it.

Has anybody experienced that before?

Thank
 
B

Bernie Deitrick

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
 
L

Lana

Sad as it may come.
Maybe I should do back-ups.
Star Office you said?

will look into google for it.

Thanks Bernie.
Thank you very much.

And god bless this forum: three problems per day is well not bad
 
Top