In my office we have a network drive that everyone can access. I should also mention everyone uses exactly the same PC with exactly the same hardware/software as we're regulated by the "Help" desk here.
One of my colleagues has stored several Excel files on the network share I mentioned above. I can open most of these files which range in size from 3MB to 17.5MB. There are a few files though that just dive when I open them. At first I thought size had something to do with it, but that's not the case. Some 17.5MB files work perfectly, others tank.
Here's what happens...
When I open one of the files in question everything looks fine. If I click on one of the multiple worksheet tabs across the bottom the sheet changes but the tab I just selected does not become highlighted. As I click between sheets the screen changes, but only partially. It's like the screen doesn't refresh and it keeps drawing over the screen without taking away what was there.
I had another colleague of mine open the files on his computer and everything worked perfectly. Our page file sizes are the same and our hardware is the same.
Any other ideas on what could be causing Excel to bog on my PC? Is there something I can check in Excel itself?
I attached a screenshot as an example. I just scrolled down the page so the data wouldn't be shown to the world - that's why the sheet is blank.
Last edited by The_Grudge; May 24th, 2007 at 10:12 AM.
Reply With Quote