J
John Hood
Transcript of Helpdesk session with solution:
User reports Excel is "going nuts" Every time she opens it, Excel
starts opening all sorts of files. Some of them DOC PPT etc, and
they are erroring out. On Site.
True confessions time: She was changing her "Options" "General" to
open the S drive by default and accidentally changed "At Startup, Open
all files in" to s:\ as well. Excel was trying to open every file on
her S drive (which has a couple of thousand files on it).
From Google:
Delete *.xlb - no help
Delete personal.xls - no help
Delete everything in XLSTART folder - nothing there.
Detect and repair - no help.
RUN, Excel /safe - Excel opens without the file cascade. All of the
files are listed in Help, About, "Disabled Items". Couldn't find how
to permanently remove them. Went to change the Options, General "At
Startup, Open all files in" but it was blank (I was in safe mode) - no
help there either.
Needed to open Excel normally without the file explosion.
Finally resorted to disconnecting her S drive from the server. (right
click "Disconnect") and remapping s to her empty C:\temp folder
(Start RUN: Net Use S: \\127.0.0.1\c$\temp)
Open Excel normally. Clear the error messages. Options, General
"At Startup, Open all files in" said "S:\" MUCH REJOICING. Removed
it. Closed Excel. Remapped S:\ back to where it was. Opened Excel.
End of problem.
And yes, in fact, I DO rock. Why do you ask?
John H.
User reports Excel is "going nuts" Every time she opens it, Excel
starts opening all sorts of files. Some of them DOC PPT etc, and
they are erroring out. On Site.
True confessions time: She was changing her "Options" "General" to
open the S drive by default and accidentally changed "At Startup, Open
all files in" to s:\ as well. Excel was trying to open every file on
her S drive (which has a couple of thousand files on it).
From Google:
Delete *.xlb - no help
Delete personal.xls - no help
Delete everything in XLSTART folder - nothing there.
Detect and repair - no help.
RUN, Excel /safe - Excel opens without the file cascade. All of the
files are listed in Help, About, "Disabled Items". Couldn't find how
to permanently remove them. Went to change the Options, General "At
Startup, Open all files in" but it was blank (I was in safe mode) - no
help there either.
Needed to open Excel normally without the file explosion.
Finally resorted to disconnecting her S drive from the server. (right
click "Disconnect") and remapping s to her empty C:\temp folder
(Start RUN: Net Use S: \\127.0.0.1\c$\temp)
Open Excel normally. Clear the error messages. Options, General
"At Startup, Open all files in" said "S:\" MUCH REJOICING. Removed
it. Closed Excel. Remapped S:\ back to where it was. Opened Excel.
End of problem.
And yes, in fact, I DO rock. Why do you ask?
John H.