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 exce...
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
Damien
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
Damien
To 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
