We have a user who just started getting this error. All she is trying to do
is "create a copy" of a sheet into the same workbook. Logged on as
administrator it works fine on her pc. I checked the permissions of the
server directory and she has full control of the directory and files. This
particular spreadsheet uses macros.
I thought maybe it was because she uses a mapped drive (H:) to access the
file but even going thru the UNC path it fails.
The user can add data from my pc logged on as herself so feel I have
isolated to something on her pc.
It does feel like a rights issue. Whn it fails with the
vb error, I see the
..tmp files being generated at the \\server\share level.
If the user creates a new workbook and tries to create a copy, it works
fine. Her macro security is set to medium. Any other settings that could
cause this?