New
#11
Yep, tried that a few days ago. I think I might try an SFC /SCANNOW and see if there is a system file messed up.
you could try process monitor
there is nothing to install...
...just copy the exe from the zip file and paste it on your desktop.
Filter on the process named excel.exe
When an error comes up, don't click on the error - just leave it
Then look at the info in process monitor
(starting at the bottom and work your way up)
below is a link to a post with some info on using process monitor...
...but you won't de-select the buttons/icons shown in the right part of that first image:
Missing start menu icons
I ran process monitor and when accessing my file in the process listing everything is listed as SUCCESS except 3 lines:
Event Class: File System
Operation: CreateFileMapping
Result: FILE LOCKED WITH ONLY READERS
Path: ***Removed for security reasons
TID: 7452
Duration: 0.0000020
SyncType: SyncTypeCreateSection
PageProtection: PAGE_READONLY
===========================================
Date & Time: 2/14/2013 12:08:48 PM
Event Class: File System
Operation: CreateFileMapping
Result: FILE LOCKED WITH WRITERS
Path: ***Removed for security reasons
TID: 7452
Duration: 0.0000017
SyncType: SyncTypeCreateSection
PageProtection: PAGE_READWRITE
==========================================
Date & Time: 2/14/2013 12:08:48 PM
Event Class: File System
Operation: CreateFile
Result: ACCESS DENIED
Path: C:\Users\SYSTEM\AppData\Local\Temp\~DFF8048AEBC14E534D.TMP
TID: 7452
Duration: 0.0000907
Desired Access: Generic Read/Write, Delete
Disposition: Create
Options: Synchronous IO Non-Alert, Non-Directory File, Delete On Close
Attributes: T
ShareMode: Read, Write, Delete
AllocationSize: 0
Last edited by zarknoid; 14 Feb 2013 at 13:36.
When I open one with double click and it works, there is no line with ACCESS DENIED. I think that's the problem. Possibly not enough rights to create the temp file?
When I gave full rights to users to this temp directory it works!
But shouldn't this path have the logged in user in it? My TEMP variable contains:
c:\Users\%USERNAME%\AppData\Local\Temp
Somehow SYSTEM is getting put in place of the USERNAME
Good detective work
I Googled "\Users\SYSTEM\AppData" (with the quotation marks) and found some things about symbolic links, getting around the UAC and the temp environmental OS variable. But you mentioned earlier that the problem file could be moved to your desktop and it would open without issue... so the OS temp variable is probably not the issue.
I don't have much time to look thru Google's returns right now - maybe if you dig thru them, something will come to mind.