ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multiple worksheets open on starting Excel. (https://www.excelbanter.com/excel-discussion-misc-queries/21817-multiple-worksheets-open-starting-excel.html)

Jerry

Multiple worksheets open on starting Excel.
 
A week ago I placed 4 shortcuts on my desktop pointing to Excel worksheets.
Now when I open one of them or just launch Excel from the menu, it
automatically opens about 16 of my worksheets. If I launch from one of my
shortcuts, the file I launched is the last one to open. Can someone tell me
what I've done and how to fix it?

Chip Pearson

Go to the Tools menu, choose Options, then the General tab.
There, ensure "Alternate Startup Directory" or "At startup, open
all files in:" is empty.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jerry" wrote in message
...
A week ago I placed 4 shortcuts on my desktop pointing to Excel
worksheets.
Now when I open one of them or just launch Excel from the menu,
it
automatically opens about 16 of my worksheets. If I launch
from one of my
shortcuts, the file I launched is the last one to open. Can
someone tell me
what I've done and how to fix it?




Jerry

Thanks Chip. This was driving me nuts. My Options dialog box doesn't say
"At startup, open all files in:" so I never made the connection. Thanks
again.

"Chip Pearson" wrote:

Go to the Tools menu, choose Options, then the General tab.
There, ensure "Alternate Startup Directory" or "At startup, open
all files in:" is empty.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jerry" wrote in message
...
A week ago I placed 4 shortcuts on my desktop pointing to Excel
worksheets.
Now when I open one of them or just launch Excel from the menu,
it
automatically opens about 16 of my worksheets. If I launch
from one of my
shortcuts, the file I launched is the last one to open. Can
someone tell me
what I've done and how to fix it?





Chip Pearson

Jerry,

Older versions of Excel used the phrase "Alternate Startup
Directory", which isn't very descriptive. Later versions use the
phrase "At startup, open all files in:", which is a more clear
description.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Jerry" wrote in message
...
Thanks Chip. This was driving me nuts. My Options dialog box
doesn't say
"At startup, open all files in:" so I never made the
connection. Thanks
again.

"Chip Pearson" wrote:

Go to the Tools menu, choose Options, then the General tab.
There, ensure "Alternate Startup Directory" or "At startup,
open
all files in:" is empty.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jerry" wrote in message
...
A week ago I placed 4 shortcuts on my desktop pointing to
Excel
worksheets.
Now when I open one of them or just launch Excel from the
menu,
it
automatically opens about 16 of my worksheets. If I launch
from one of my
shortcuts, the file I launched is the last one to open. Can
someone tell me
what I've done and how to fix it?








All times are GMT +1. The time now is 08:48 PM.

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