obscure problem

[Guest]

I dont expect too much help with this issue as I can only provide a limited
amount of information.

The situation is a corporate network, one employee has physically moved
desks. When she logs in on her old pc she is able to open, access, and use a
network copy of an excel spreadsheet. Now that she has moved desks, and
computers, she can access, and open the same network copy of the excel
spreadsheet, however when it loads, and she tries to access the first two
sheets, all she gets is empty cells. I have checked and ensured the macro
security is set to the same on both pc's. I am a little lost as to what
could be different from one of these pc's to the other. She has the same
network access and permissions as well, running the same os and same version
of office. What could cause an excel spreadsheet to open fine on one pc, and
not another.... I should also mention that she can also open any of the other
spreadsheets she works on, it is only one in particular.

Any general thoughts or suggestions would be appreciated, thanks in advance.

 

[Mark Lincoln]

Now that's an interesting problem, indeed, and I regret that I have no
answer. Some thoughts:

Are you certain this PC is opening the same file? Might it be opening
a (corrupt) copy?

Have you tried opening the same file from other PCs on the network?
Do any others have the same problem?

Can you exchange the two computers?

Is there anything the workbook accesses when opened that, if not found
or if not valid for some reason, would hide information? For example,
a settings file?

Good luck. I'll be very interested to know what the answer is.

Mark Lincoln

 

[Guest]

Mark, you mentioned a 'settings file' - it might also be that the information
for the cells that are not being filled were being filled from another Excel
file that was on the other PC but is not on the new one. If those cells are
being filled via VBA code and if there's sufficient error trapping to ignore
errors (file not found), then that could explain things.

Kelly: Mark has offered some good troubleshooting steps. I might offer
another - make a copy of the workbook and leave it in the same location as
the original. Open that copy and go into the VB Editor and find the code
that is supposed to be filling the cells. Just above the first executable
statement in that code section (I suspect you'll find it either in the
Workbook_Open() event or perhaps a Worksheet_Activate() event) ) add a new
line and put the word STOP in that new line. Save and close the workbook.
Reopen it.

When the line with the STOP instruction is encountered, code execution will
stop, the VB Editor will open and the Stop instruction will be highlighted as
the current statement. Start pressing the [F8] key to single-step through
the code from there. You'll be able to see when/where it jumps out of the
code without finishing its job. That should give you some clue as to why
it's not working properly.

If you never see the VB Editor open with the Stop statement highlighted, it
means that code is not getting executed for some reason: either no code is
being run, or you chose the wrong code module/Sub/Function to examine.

When you finally run things down, don't forget to remove the STOP statement
from the code.