Thread: obscure problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mark Lincoln Mark Lincoln is offline
external usenet poster
 
Posts: 227
Default obscure problem

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

On Oct 2, 12:05 pm, Kelly Armitage
wrote:
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.
:)