Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
opens an extra workbook
Everytime I open any of my Excel files it now opens an additional (and
unwanted) workbook. It never used to do this, how do I stop this from happening? Thanks, Joanne |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
opens an extra workbook
Hi Joanne
Maybe this ? http://www.contextures.com/xlfaqApp.html#TwoWindows -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Joanne" wrote in message ... Everytime I open any of my Excel files it now opens an additional (and unwanted) workbook. It never used to do this, how do I stop this from happening? Thanks, Joanne |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
opens an extra workbook
Thanks Ron, but unfortunately that is not it. When I open the file I get the
workbook I want and then a second blank workbook labelled "book 1". I have tried the close and save suggestion but it still opens a blank "book 1" again the next time I open the file. Joanne "Ron de Bruin" wrote: Hi Joanne Maybe this ? http://www.contextures.com/xlfaqApp.html#TwoWindows -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Joanne" wrote in message ... Everytime I open any of my Excel files it now opens an additional (and unwanted) workbook. It never used to do this, how do I stop this from happening? Thanks, Joanne |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
opens an extra workbook
A blank book or a particular book?
Gord Dibben MS Excel MVP On Wed, 3 Oct 2007 10:58:02 -0700, Joanne wrote: Everytime I open any of my Excel files it now opens an additional (and unwanted) workbook. It never used to do this, how do I stop this from happening? Thanks, Joanne |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
opens an extra workbook
A blank one.
Joanne "Gord Dibben" wrote: A blank book or a particular book? Gord Dibben MS Excel MVP On Wed, 3 Oct 2007 10:58:02 -0700, Joanne wrote: Everytime I open any of my Excel files it now opens an additional (and unwanted) workbook. It never used to do this, how do I stop this from happening? Thanks, Joanne |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
opens an extra workbook
What does your command line look like in Folder OptionsFile Types?
Go to StartSettingsControl PanelFolder OptionsFile Types If using WinXP OS you would scroll down to .XLS then "Advanced"OpenEdit. 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 Dibben MS Excel MVP On Wed, 3 Oct 2007 12:25:00 -0700, Joanne wrote: A blank one. Joanne "Gord Dibben" wrote: A blank book or a particular book? Gord Dibben MS Excel MVP On Wed, 3 Oct 2007 10:58:02 -0700, Joanne wrote: Everytime I open any of my Excel files it now opens an additional (and unwanted) workbook. It never used to do this, how do I stop this from happening? Thanks, Joanne |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
opens an extra workbook
That is exactly what I have. Any other suggestions?
Joanne "Gord Dibben" wrote: What does your command line look like in Folder OptionsFile Types? Go to StartSettingsControl PanelFolder OptionsFile Types If using WinXP OS you would scroll down to .XLS then "Advanced"OpenEdit. 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 Dibben MS Excel MVP On Wed, 3 Oct 2007 12:25:00 -0700, Joanne wrote: A blank one. Joanne "Gord Dibben" wrote: A blank book or a particular book? Gord Dibben MS Excel MVP On Wed, 3 Oct 2007 10:58:02 -0700, Joanne wrote: Everytime I open any of my Excel files it now opens an additional (and unwanted) workbook. It never used to do this, how do I stop this from happening? Thanks, Joanne |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
opens an extra workbook
What do you have in your XLStart folder?
(Use windows|search to find that folder) and if you open excel and see that extra workbook, put this in A1 of the first worksheet: =cell("Filename",a1) (don't change anything in that formula) What do you see? Joanne wrote: Everytime I open any of my Excel files it now opens an additional (and unwanted) workbook. It never used to do this, how do I stop this from happening? Thanks, Joanne -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
opens an extra workbook
In the XLStart folder I have only one file and it is a pdf maker 5.0 macro
for Excel When I enter that formula in A1 of the extra book nothing appears in the cell. Joanne. "Dave Peterson" wrote: What do you have in your XLStart folder? (Use windows|search to find that folder) and if you open excel and see that extra workbook, put this in A1 of the first worksheet: =cell("Filename",a1) (don't change anything in that formula) What do you see? Joanne wrote: Everytime I open any of my Excel files it now opens an additional (and unwanted) workbook. It never used to do this, how do I stop this from happening? Thanks, Joanne -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
opens an extra workbook
If you've upgraded through different versions of excel, you could have multiple
XLStart folders. Any chance you've done that? If yes, look again through all the XLStart folders. === Since the formula returned nothing, that means that there isn't an existing .xls workbook opening. But the challenge is still to find the cause. Joanne wrote: In the XLStart folder I have only one file and it is a pdf maker 5.0 macro for Excel When I enter that formula in A1 of the extra book nothing appears in the cell. Joanne. "Dave Peterson" wrote: What do you have in your XLStart folder? (Use windows|search to find that folder) and if you open excel and see that extra workbook, put this in A1 of the first worksheet: =cell("Filename",a1) (don't change anything in that formula) What do you see? Joanne wrote: Everytime I open any of my Excel files it now opens an additional (and unwanted) workbook. It never used to do this, how do I stop this from happening? Thanks, Joanne -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opens copy of workbook | Excel Discussion (Misc queries) | |||
how do I set the tab that my workbook opens with | Excel Discussion (Misc queries) | |||
Excel workbook opens a new workbook | Excel Discussion (Misc queries) | |||
Personal workbook opens when Excel opens | Excel Discussion (Misc queries) | |||
Workbook opens twice | Excel Discussion (Misc queries) |