View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Perconal Macro Book sabotated Excel's work

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/