Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
![]()
Cross-Post (misc, programming, and setup)
Yesterday, my long standing (and reasonably simple) macros failed to function producing an error statement "Personal.xls is already open." It was not (hidden or otherwise). After much fruitless troubleshooting and web searched for similar problems, I deleted the personal.xls file and recreated the first of my macros which functioned normally. On adding a second macro, the problem recurred. Searched the entire HD for stray copies of personal.xls, found several shortcuts, deleted all. Cannot resolve this issue - any suggestions? Recent system changes: Added SP-3 to Office XP but do not believe that is related. Upgraded from Norton AntiVirus 2001 to 2004. |
#2
![]()
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
![]()
Close out of all programs
Reboot Open Explorer Navigate to c:\windows\temp Delete all files and subfolders Navigate to c:\Documents & Settings\<your user name\Temp Delete all files and subfolders Reboot "Cal" wrote in message ... : Cross-Post (misc, programming, and setup) : : Yesterday, my long standing (and reasonably simple) macros failed to : function producing an error statement "Personal.xls is already open." It : was not (hidden or otherwise). After much fruitless troubleshooting and web : searched for similar problems, I deleted the personal.xls file and recreated : the first of my macros which functioned normally. On adding a second macro, : the problem recurred. Searched the entire HD for stray copies of : personal.xls, found several shortcuts, deleted all. Cannot resolve this : issue - any suggestions? : : Recent system changes: : Added SP-3 to Office XP but do not believe that is related. : Upgraded from Norton AntiVirus 2001 to 2004. : : |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
my personal.xls file is causing problems | Excel Discussion (Misc queries) | |||
problems with personal.xls | Excel Discussion (Misc queries) | |||
Personal macro workbook and personal.xls | Excel Discussion (Misc queries) | |||
personal.htm & personal.xls in Macro | Excel Programming |