MWE
02-08-2012, 03:44 PM
I recently purchased a new computer with Win7 (64 bit). I hate Office2007/2010 so I loaded Office2003 as a 32 bit application. I have noticed a number of funny things in Excel:
Excel files on the C: drive can not be opened. The file is physically there and can be seen using a file manager, but when I try to open it, I get an error indicating that the file can not be found. Files on any other partition open OK. I do not normally store any data files on the C: drive, but did stumble across this strange behavior
after a bit of fiddling, I figured out where to locate my personal.xls file (copied over from an XP system). This is an exception to the problem above. It "opens" correctly when I open Excel but macros in that file do not execute as I would expect. On my XP machines, the "target" workbook for the macros is whatever the activeworkbook is. On the Win7 machine, they assume that Personal.xls is the activeworkbook.Has anyone else experienced this type of behavior?
Excel files on the C: drive can not be opened. The file is physically there and can be seen using a file manager, but when I try to open it, I get an error indicating that the file can not be found. Files on any other partition open OK. I do not normally store any data files on the C: drive, but did stumble across this strange behavior
after a bit of fiddling, I figured out where to locate my personal.xls file (copied over from an XP system). This is an exception to the problem above. It "opens" correctly when I open Excel but macros in that file do not execute as I would expect. On my XP machines, the "target" workbook for the macros is whatever the activeworkbook is. On the Win7 machine, they assume that Personal.xls is the activeworkbook.Has anyone else experienced this type of behavior?