If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
##name? in cells of spreadsheet
I received a call from one of the users I support on the job yesterday, she
has a spreadsheet displaying "##name?" in a few cells of spreadsheet. When the same spreadsheet is displayed on another user's PC it displays fine. It is a gigantic spreadsheet, over 20 sheets. The problem does not happen to the person next to her, so I am thinking it can be an Excel add-in or function on the local PC side, she is the only user complaining of this and it is in only one part of this huge spreadsheet. The next thing I will bring up is that this spreadsheet is protected and cannot be modified by anyone that opens it. Both users are running XPsp2 and Office 2003 sp2 as well. Any insight would be greatly appreciated, Thanks all- |
#2
|
|||
|
|||
##name? in cells of spreadsheet
I'd start by turning on the Analysis toolpak (via Tools|Addins).
Shawn wrote: I received a call from one of the users I support on the job yesterday, she has a spreadsheet displaying "##name?" in a few cells of spreadsheet. When the same spreadsheet is displayed on another user's PC it displays fine. It is a gigantic spreadsheet, over 20 sheets. The problem does not happen to the person next to her, so I am thinking it can be an Excel add-in or function on the local PC side, she is the only user complaining of this and it is in only one part of this huge spreadsheet. The next thing I will bring up is that this spreadsheet is protected and cannot be modified by anyone that opens it. Both users are running XPsp2 and Office 2003 sp2 as well. Any insight would be greatly appreciated, Thanks all- -- Dave Peterson |
#3
|
|||
|
|||
##name? in cells of spreadsheet
Yes, after I posted I read something mentioning that add-in. I will try and
report the outcome, Thanks Dave- "Dave Peterson" wrote: I'd start by turning on the Analysis toolpak (via Tools|Addins). Shawn wrote: I received a call from one of the users I support on the job yesterday, she has a spreadsheet displaying "##name?" in a few cells of spreadsheet. When the same spreadsheet is displayed on another user's PC it displays fine. It is a gigantic spreadsheet, over 20 sheets. The problem does not happen to the person next to her, so I am thinking it can be an Excel add-in or function on the local PC side, she is the only user complaining of this and it is in only one part of this huge spreadsheet. The next thing I will bring up is that this spreadsheet is protected and cannot be modified by anyone that opens it. Both users are running XPsp2 and Office 2003 sp2 as well. Any insight would be greatly appreciated, Thanks all- -- Dave Peterson |
#4
|
|||
|
|||
##name? in cells of spreadsheet
I have tried adding the "Analysis Toolpack" and the "VBA Analysis toolpack"
as well, still get the same ##name$ in the cells. I exited office and restarted office, when I go back in its still there. I have to still try I detect and repair if possible, then try a clean re-install i guess. It appears to be local to this user Thanks- "Shawn" wrote: Yes, after I posted I read something mentioning that add-in. I will try and report the outcome, Thanks Dave- "Dave Peterson" wrote: I'd start by turning on the Analysis toolpak (via Tools|Addins). Shawn wrote: I received a call from one of the users I support on the job yesterday, she has a spreadsheet displaying "##name?" in a few cells of spreadsheet. When the same spreadsheet is displayed on another user's PC it displays fine. It is a gigantic spreadsheet, over 20 sheets. The problem does not happen to the person next to her, so I am thinking it can be an Excel add-in or function on the local PC side, she is the only user complaining of this and it is in only one part of this huge spreadsheet. The next thing I will bring up is that this spreadsheet is protected and cannot be modified by anyone that opens it. Both users are running XPsp2 and Office 2003 sp2 as well. Any insight would be greatly appreciated, Thanks all- -- Dave Peterson |
#5
|
|||
|
|||
##name? in cells of spreadsheet
Without a clue to what the formula is, my guesses are limited.
Maybe you can go back to the developer and ask him or her what the formula is--maybe they have a solution for you. Shawn wrote: I have tried adding the "Analysis Toolpack" and the "VBA Analysis toolpack" as well, still get the same ##name$ in the cells. I exited office and restarted office, when I go back in its still there. I have to still try I detect and repair if possible, then try a clean re-install i guess. It appears to be local to this user Thanks- "Shawn" wrote: Yes, after I posted I read something mentioning that add-in. I will try and report the outcome, Thanks Dave- "Dave Peterson" wrote: I'd start by turning on the Analysis toolpak (via Tools|Addins). Shawn wrote: I received a call from one of the users I support on the job yesterday, she has a spreadsheet displaying "##name?" in a few cells of spreadsheet. When the same spreadsheet is displayed on another user's PC it displays fine. It is a gigantic spreadsheet, over 20 sheets. The problem does not happen to the person next to her, so I am thinking it can be an Excel add-in or function on the local PC side, she is the only user complaining of this and it is in only one part of this huge spreadsheet. The next thing I will bring up is that this spreadsheet is protected and cannot be modified by anyone that opens it. Both users are running XPsp2 and Office 2003 sp2 as well. Any insight would be greatly appreciated, Thanks all- -- Dave Peterson -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|