ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   multiple workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/185688-multiple-workbooks.html)

Davigirl

multiple workbooks
 
I am using Excel 97 and when I open it up I have 3 workbooks that open up
automatically, I would like to know how to make it where I have to choose
which workbooks I want open.

Gord Dibben

multiple workbooks
 
Are the three workbooks unique or just copies of one?

Do you see filename.xls:1 and filename.xls:2 and filename.xls:3?

If so, these are windows of the same workbook.

Just close a couple of them them save the remaining one.

If not the above, maybe you are opening a workspace file with extension of xlw

Alternate solution.............remove all the workbooks from XLSTART folder or
delete any pathname you may have in Alternate Startup Folder Location found
under ToolsOptionsGeneral


Gord Dibben MS Excel MVP


On Wed, 30 Apr 2008 11:02:00 -0700, Davigirl
wrote:

I am using Excel 97 and when I open it up I have 3 workbooks that open up
automatically, I would like to know how to make it where I have to choose
which workbooks I want open.



Davigirl

multiple workbooks
 
Thanks very much that helped now when I open excel only one blank book opens
and that is ok with me .

"Gord Dibben" wrote:

Are the three workbooks unique or just copies of one?

Do you see filename.xls:1 and filename.xls:2 and filename.xls:3?

If so, these are windows of the same workbook.

Just close a couple of them them save the remaining one.

If not the above, maybe you are opening a workspace file with extension of xlw

Alternate solution.............remove all the workbooks from XLSTART folder or
delete any pathname you may have in Alternate Startup Folder Location found
under ToolsOptionsGeneral


Gord Dibben MS Excel MVP


On Wed, 30 Apr 2008 11:02:00 -0700, Davigirl
wrote:

I am using Excel 97 and when I open it up I have 3 workbooks that open up
automatically, I would like to know how to make it where I have to choose
which workbooks I want open.




Gord Dibben

multiple workbooks
 
I gave three or four alternatives...........which one or ones did the trick?

BTW.......you can stop the blank workbook from opening also if you wished.


Gord

On Thu, 1 May 2008 08:10:09 -0700, Davigirl
wrote:

Thanks very much that helped now when I open excel only one blank book opens
and that is ok with me .

"Gord Dibben" wrote:

Are the three workbooks unique or just copies of one?

Do you see filename.xls:1 and filename.xls:2 and filename.xls:3?

If so, these are windows of the same workbook.

Just close a couple of them them save the remaining one.

If not the above, maybe you are opening a workspace file with extension of xlw

Alternate solution.............remove all the workbooks from XLSTART folder or
delete any pathname you may have in Alternate Startup Folder Location found
under ToolsOptionsGeneral


Gord Dibben MS Excel MVP


On Wed, 30 Apr 2008 11:02:00 -0700, Davigirl
wrote:

I am using Excel 97 and when I open it up I have 3 workbooks that open up
automatically, I would like to know how to make it where I have to choose
which workbooks I want open.






All times are GMT +1. The time now is 03:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com