1 Attachment(s)
My PC and some Excel files - Not working well
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.
Re: My PC and some Excel files - Not working well
Try running the following macro:
Code:
Application.ScreenUpdating = True
If this solves the issue (at least temporarily) then the issue is likely to be caused by a macro/program turning this property off, and not turning it back on again.
Re: My PC and some Excel files - Not working well
That made things better, but not 100%.
All of the sheets work fine except for the two sheets that hold a graph. When I click one of those the problem starts again.
I don't see any Macros in the workbook though (except for the one you had me add).
Is there a way to tell what Macros are being run or view all code associated with the worksheet?
Re: My PC and some Excel files - Not working well
What I would do is go into the VB Editor, and look thru each object in the Project Explorer window (eg: open the Sheet1 object, and see what subs/functions it contains).
Hopefully something should be obvious from that.
Re: My PC and some Excel files - Not working well
Update: If I go into Microsoft Script Editor in Excel and then minimize it, a little toolbar comes up with two icons - REFRESH and DO NOT REFRESH. If I hit the REFRESH button it seems to solve the issues, but again, only for all worksheets except the ones with a big graph. My officemate continues to have no problems with any of the files. It's a local issue for sure.
Thanks. I tried that but I'll go back again and take a closer look.
What's wierd is that the other guy sitting in my office can open and work with these sheets and have no issue.
Bizarre.