Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
obscure problem
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. :) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. :) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
obscure problem
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. "Mark Lincoln" wrote: 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. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Obscure Function | Excel Worksheet Functions | |||
Obscure Function | Excel Worksheet Functions | |||
Combination chart: primary data labels obscure line series on secondary axis | Charts and Charting in Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
Obscure Question | Excel Discussion (Misc queries) |