Recently I have begun to have a problem with an excel sheet. It is located on our company P Drive.
This workbood was for the year 2003. It used to open really quickly. Now it just waits and waits and takes about 15 - 45 minutes to open and to save.
I go to another computer (exactly the same as mine) and it takes 30 seconds to open and to save.
Now I was using the same workbook for 2002. (different copy of it for 2003) The 2002 worked fine. Now all of a sudden this original workbook is the same in terms of slowness.
I disabled my virus scan. Thinking the book was scanning. I tried reinstalling Excel. Taking it off then putting all of MS Office back.
I have 254 RAM (just like the other computers do) 85% free space on my C drive. 60% free on the P drive.
I don’t understand why it is just this workbook. All other workbooks, some a LOT larger open really quickly.
Just as a place to start, let me see if I’ve got it all. The 2002 workbook used to work fine on your computer, and the 2003 workbook is a copy of the 2002, modified for 2003. As of now, both are unusably slow on your machine, but work fine on other computers.
They are both on the P: drive, which is a network drive not on your computer. So, when you access them from another computer, you are accessing the very same files.
And, you’ve reinstalled Office.
A first stab or two would be to 1.) check your network connnection (everything else you access from the server’s OK?) and 2.) check to see if perhaps these files were accidentally saved to your local drive, and have become corrupted. Do these files link to other files?
Most likely Ringo has the first two correct (I somewhat think that the last one is wrong…its a network…so I’d think they’d want them linked? (sory I seem arrogant))
Sounds like a good idea. The thing I don’t get is the 2002 workbook is on my C drive. (the P is the Public Drive). The 2002 was NEVER and isn’t on the P drive.
The microsoft site says check your network links too, but our MIS person isn’t handy…so I was hoping there would be something simple…You know like I had a box checked somewhere that was slowing it down.
It is so odd that it takes 40 minutes on my computer and 30 seconds on another.
No it is weird, even while I am trying to open the Excel document. I can open another Excel Document. I can open and run Access. The only thing I can’t due is send an email. I use Outlook and it says when I go to make a new email…You do not have enuff memory for this operation. I was wondering if this workbook could be grabbing all my memory to opening it.
There was an old problem with Office 97 and the journalling feature in Outlook. You get around it by doing this:
Start Microsoft Outlook.
On the Tools menu, click Options.
Click the Journal tab.
In the “Also record files from” list, clear all of the check boxes.
Click Apply, and then click OK.
But usually when this is the problem it affects all files. Other things to consider are defragging your drive and deleting any old .tmp files in your temp folder.
My first guess is that data transmission over your network (P:) is slower than local (C:). Maybe Excel has nothing to do with it.
Try copying a file of approximately the same size as your excel file (or exactly that file) from one folder on the P: drive to another on the same drive. Compare this to the same copy operation C:->C:. If the P:->P: copy is very slow, it may be a network interface problem (bad cable, bad card, corrupted network software, etc.).
I have defragged and scanned the computer for errors. I ran the latest virus DAT file and scanned the drive. All OK
I also deleted my .TMP and .CHK files.
I am only having problems with this file. I thought at first it must be a corrupted file. You see the original file was on my C drive. This was the file for 2002 It worked fine from Jan - Mid December. Then my company sent me the workbook for 2003
I put the workbook on the public drive as I wanted the Sales Director to be able to see it. Both workbooks worked fine. Obvioulsy this wasn’t a direct copy on my part, something I failed to state earlier.
Then about a week ago the 2003 book became slow. So I simply deleted it (figuring it was corrupt) and recopied it from the email it was sent with to start with.
It worked fine. I know loaded data into it. Then after printing it out, I closed it and showed my director the print out. He wanted to make a change. I reopened it and it has been screwy ever since. Then after coming back from Christmas I said “why do I have this trouble, the first book doesn’t do this.” I opened that book, the 2002 book on the C drive and it was doing the same thing. Taking 50 minutes to open.
I have no problem with any other excel file. If I recopy it from the original it takes forever to open.
I took MS Office off of the computer. The I reinstalled it. I networked into my computer from other computers in my office and the file opens in 30 seconds. On machines much smaller in RAM than mine.
I forwarded the orginal email to another person who has EXCEL at home. The file opens fine.
The only other thing I can say this Workbook is full of macros, which I know can be buggy. But I would assume they would be buggy on more than just my computer. The workbook is passcoded so I can’t see anything. All you can do is enter data and print.
After much searching someone told me that Excel creates a file with a ~ on it in your Windows --> Temp folder. Although I had deleted out my .tmp and .chk files there was over 4000 other files in there. Mostly .wmf and .emf files. Once I deleted these out it worked fine.