Forum Discussion
Issue with excel on a shared computer
We have a shared computer with different users in our department. The first user that first used that computer does not have issues.
I myself after creating the second user faced an issue with excel. Macros that run on every other computer do not work. Strange error messages that do not make sense.
So I tried to record some simple commands with macro recorder to have a look at it. What VBA editor showed was completely different from the commands i recorded. The commands I can see are strange and coloured in red.
The issue described is the issue I already realized. But as the first user on the same computer can work without issues I assume a problem with the setup of the second user. Went through all excel settings but did not find any clue.
- Hi Volker
Hard to tell without being able to see it.
Did you see anything in the code that is hard coding itself to the first user? It may be why you are experiencing errors as a hard coded file path (as an example) may not be accessible from your account if you don't have the permissions to access it.
Good luck!
Cheers
DamienTo clarify my issue:
I recorded a macro.
The following action was done during recording:
wrote "Hallo" into Cell A1.
Here is what the VBA editor gives to me:
Sub Macro1()
'
' Macro1 Macro
''
ShowDrillIndicators. = "Hallo"
Range("A2").Count
End SubI never saw or read the command "ShowDrillIndicators
Hi Volker
I'm not sure what's happening with the way it's not doing what you expect, but at the very least ShowDrillIndicators is a legit thing for PivotTable.
Maybe a coding expert here will know why one user is fine and the other is not? Hopefully you get it resolved soon!
Cheers
Damien
