ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I stop Book 1 opening with existing files? (https://www.excelbanter.com/excel-discussion-misc-queries/80984-how-do-i-stop-book-1-opening-existing-files.html)

sirbob

How do I stop Book 1 opening with existing files?
 
Whenever I open an existing Excel file, a Book 1 sheet opens also. Does
anyone know how to stop this happening, please?

CaptainQuattro

How do I stop Book 1 opening with existing files?
 

Book1 is probably saved in your XLStart Directory in your Excel folder.

Locate this directory and delete the file.

Also check if you have an alternative startup directory set.

Click Tools Options General


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=528880


sirbob

How do I stop Book 1 opening with existing files?
 
Thanks for the suggested help. As you suggested I have searched for and
found €śXLSTART€ť in 2 locations, but both folders are empty with 0 bytes.

I have also looked in Excel Tools Options General, and the €śAt
start-up open with€ť box is unchecked and there is no entry in the box

I do not know how to tell whether I have an alternative Startup directory
set, but I have searched the PC and found a number of Startup folders, none
of which contain anything except a €śdesktop.ini€ť file.

Unhappily the problem remains. Is there anything else that I can do, please?


"CaptainQuattro" wrote:


Book1 is probably saved in your XLStart Directory in your Excel folder.

Locate this directory and delete the file.

Also check if you have an alternative startup directory set.

Click Tools Options General


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=528880




All times are GMT +1. The time now is 04:58 PM.

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