M
MCHSI
When I open an existing file, Excel also wants to open a blank workbook1.xls
as well?
as well?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
MCHSI
When I open an existing file, Excel also wants to open a blank workbook1.xls
as well?
as well?
H
Harlan Grove
MCHSI said:When I open an existing file, Excel also wants to open a blank workbook1.xls
as well?
How are you opening the file? With Excel already running using its
File > Open menu command? Or by double clicking on the file's entry in
Windows Explorer? Or something else?
G
Gord Dibben
Could be you have a book.xls or book.xlt in your XLSTART folder.
Or...............
Try re-registering Excel.
Close Excel first and on the Windows Taskbar
1) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver
You might have to designate a full path to excel.exe.
In that case Start>Run "C:\yourpath\excel.exe /regserver"(no quotes)>OK.
Gord Dibben MS Excel MVP
Or...............
Try re-registering Excel.
Close Excel first and on the Windows Taskbar
1) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver
You might have to designate a full path to excel.exe.
In that case Start>Run "C:\yourpath\excel.exe /regserver"(no quotes)>OK.
Gord Dibben MS Excel MVP
D
Dave Peterson
Are you sure that it's named workbook1.xls?
Try this in A1 of any sheet in that workbook:
=cell("filename",a1)
If the formula returns some non-blank entry, make a note of that location, close
the workbook and use windows explorer to delete it.
If the formula returns an empty cell, then look in your XLStart folder (use
windows start button|Search for it--and you may find multiple folders with that
name) and look for workbooks in that/those folders that don't belong there.
Post back with the names of the files in those folders if you're not sure what
belongs and what doesn't.
Try this in A1 of any sheet in that workbook:
=cell("filename",a1)
If the formula returns some non-blank entry, make a note of that location, close
the workbook and use windows explorer to delete it.
If the formula returns an empty cell, then look in your XLStart folder (use
windows start button|Search for it--and you may find multiple folders with that
name) and look for workbooks in that/those folders that don't belong there.
Post back with the names of the files in those folders if you're not sure what
belongs and what doesn't.
M
MCHSI
2nd file is named book1 not workbook1
formula returned blank
i searched for xlstart folder and found nothing
hmmmm...
formula returned blank
i searched for xlstart folder and found nothing
hmmmm...
M
MCHSI
i can't locate an xlstart folder????
Gord Dibben said:Could be you have a book.xls or book.xlt in your XLSTART folder.
Or...............
Try re-registering Excel.
Close Excel first and on the Windows Taskbar
1) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver
You might have to designate a full path to excel.exe.
In that case Start>Run "C:\yourpath\excel.exe /regserver"(no quotes)>OK.
Gord Dibben MS Excel MVP
M
MCHSI
dbl clicking file in windows explorer.
Harlan Grove said:How are you opening the file? With Excel already running using its
File > Open menu command? Or by double clicking on the file's entry in
Windows Explorer? Or something else?
G
Gord Dibben
You must have one if you have Office installed.
Could be either of or both the below places.
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART
C:\Program Files\Microsoft Office\OFFICE11\XLSTART
Make sure that My Computer>Tools>Folder Options>View "Show hidden files and
folders" is enabled.
Gord
Could be either of or both the below places.
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART
C:\Program Files\Microsoft Office\OFFICE11\XLSTART
Make sure that My Computer>Tools>Folder Options>View "Show hidden files and
folders" is enabled.
Gord
D
Dave Peterson
My bet is that you didn't search for hidden folders.
Try this:
Open excel
hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window.
Type this and hit enter:
?application.startuppath
(? is short for print)
for me (xl2003, winXP Home), I get:
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART
Select that whole returned string and rightclick|Copy.
Then windows|start button|run
and paste that string into that run box.
Click the OK button and see what's in that folder.
Try this:
Open excel
hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window.
Type this and hit enter:
?application.startuppath
(? is short for print)
for me (xl2003, winXP Home), I get:
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART
Select that whole returned string and rightclick|Copy.
Then windows|start button|run
and paste that string into that run box.
Click the OK button and see what's in that folder.
M
MCHSI
OK - found that folder - odd that searching for XLSTART with the new windows
search tool - didn't find the folder! It only found these news files on the
PC. At any rate, XLSTART is empty. I ran the 2 items below - but still get
my file plus another book1 opening up.
JDS
search tool - didn't find the folder! It only found these news files on the
PC. At any rate, XLSTART is empty. I ran the 2 items below - but still get
my file plus another book1 opening up.
JDS
M
MCHSI
See prior post - I did find it - empty though. Problem still exists.
JDS
JDS
G
Gord Dibben
Did you try the re-registering steps?
What does your command line look like in Folder Options>File Types?
Go to Start>Settings>Control Panel>Folder Options>File Types
If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.
In Command line the path should be similar to this....
"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e
You must have the double quotes and the <space>/e prevents a new book from
opening.
Below have "use DDE" checked and this in the DDE message box....[open("%1")]
Application should read "Excel"(no quotes)
Gord
What does your command line look like in Folder Options>File Types?
Go to Start>Settings>Control Panel>Folder Options>File Types
If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.
In Command line the path should be similar to this....
"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e
You must have the double quotes and the <space>/e prevents a new book from
opening.
Below have "use DDE" checked and this in the DDE message box....[open("%1")]
Application should read "Excel"(no quotes)
Gord
D
Dave Peterson
Time to check for more than one XLStart folder.
Windows start button|Run
Cmd
(to get to a command prompt)
cd\
(to get to the root directory)
dir xlstart /s
Make a note of each one you find and check each for more files.
Windows start button|Run
Cmd
(to get to a command prompt)
cd\
(to get to the root directory)
dir xlstart /s
Make a note of each one you find and check each for more files.
See prior post - I did find it - empty though. Problem still exists.
JDS
H
Harlan Grove
....MCHSI said:dbl clicking file in windows explorer.
At the outer edge of possibility, the DDE message for the Open action
in Explorer could have picked up an extraneous [new()] to go with the
[open("%1")]. You'd need to check in Windows Explorer using the menu
command Tool > Folder Options... to display the Folder Options dialog,
choose the File Types tab, select the XLS extension in the list box,
click on the Advanced button to display the Edit File Type dialog,
select the Open action, click on the Edit... button to display the
Editing[...] dialog, and see what the DDE message field contains. It
should be just
[open("%1")]
M
MCHSI
yep appears to be the same as you typed below:
[open("%1")]
[open("%1")]
Harlan Grove said:...MCHSI said:dbl clicking file in windows explorer.
At the outer edge of possibility, the DDE message for the Open action
in Explorer could have picked up an extraneous [new()] to go with the
[open("%1")]. You'd need to check in Windows Explorer using the menu
command Tool > Folder Options... to display the Folder Options dialog,
choose the File Types tab, select the XLS extension in the list box,
click on the Advanced button to display the Edit File Type dialog,
select the Open action, click on the Edit... button to display the
Editing[...] dialog, and see what the DDE message field contains. It
should be just
[open("%1")]
M
MCHSI
2 on the machine - 2 users actually use the machine. No files in either!
argghh...
argghh...
M
MCHSI
Gord:
I did re-register - appeared to be running thru installation again - I
assume that would be normal.
File Types command line is - "C:\Program Files\Microsoft
Office\OFFICE11\EXCEL.EXE" /e - same as you have pasted.
Application does read Excel - no quotes.
Baffled...........
I did re-register - appeared to be running thru installation again - I
assume that would be normal.
File Types command line is - "C:\Program Files\Microsoft
Office\OFFICE11\EXCEL.EXE" /e - same as you have pasted.
Application does read Excel - no quotes.
Baffled...........
Gord Dibben said:Did you try the re-registering steps?
What does your command line look like in Folder Options>File Types?
Go to Start>Settings>Control Panel>Folder Options>File Types
If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.
In Command line the path should be similar to this....
"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e
You must have the double quotes and the <space>/e prevents a new book from
opening.
Below have "use DDE" checked and this in the DDE message
box....[open("%1")]
Application should read "Excel"(no quotes)
Gord
OK - found that folder - odd that searching for XLSTART with the new
windows
search tool - didn't find the folder! It only found these news files on
the
PC. At any rate, XLSTART is empty. I ran the 2 items below - but still
get
my file plus another book1 opening up.
JDS
D
Dave Peterson
I'm out of ideas.
2 on the machine - 2 users actually use the machine. No files in either!
argghh...
M
MCHSI
I'm an idiot (blind too!) There were 3 Directories and in the 3rd was a Add
VISIO buttons file! Removed and problem solved!!!
Thanks so much for hanging in there - everyone.
So bottom line - that file should not be written there? How would that have
happened?
VISIO buttons file! Removed and problem solved!!!
Thanks so much for hanging in there - everyone.
So bottom line - that file should not be written there? How would that have
happened?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.