Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 15th 10, 01:17 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 147
Default Excel opens in Autosave.How do I delete it so it opens in Book1?

When Excel is opened it opens as PersonalAutosave. I can close this and
Book1 is open which can be used. How can I delete PersonalAutosave and just
have Excel open in Book1? I have uninstalled Microsoft Office 2007 and
reinstalled it to no avail. This is happening in the limited access Windows
account. In the full access account Excel is working properly. Any advice
would be appreciated.

  #2   Report Post  
Old February 15th 10, 02:10 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Excel opens in Autosave.How do I delete it so it opens in Book1?

So you see a workbook named PersonalAutoSave in excel's titlebar?

If yes, then type this into A1:
=cell("filename",a1)
(don't change it from those characters)

This will show you the path, filename and even worksheet name.

Close excel and then open windows explorer.
Traverse to that folder and delete (or move to a nice save location) that file.

Another way is to open excel
With personalautosave the activeworkbook:
File|Properties|General Tab
(in xl2003 menus)

You'll see the file location there, too.

Christine wrote:

When Excel is opened it opens as PersonalAutosave. I can close this and
Book1 is open which can be used. How can I delete PersonalAutosave and just
have Excel open in Book1? I have uninstalled Microsoft Office 2007 and
reinstalled it to no avail. This is happening in the limited access Windows
account. In the full access account Excel is working properly. Any advice
would be appreciated.


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
double-click opens book1 also JaSteps Excel Discussion (Misc queries) 0 July 18th 07 03:46 AM
Book.xlt opens at startup - not Book1 Mark McDonough Excel Discussion (Misc queries) 0 May 23rd 06 04:26 PM
Excel 2K3: Opening a spreadsheet, also opens book1.xls? Newtek Excel Discussion (Misc queries) 3 July 6th 05 07:56 PM
Excel 2K3: Opening spreadsheet, also opens book1.xls? Newtek Setting up and Configuration of Excel 1 July 6th 05 07:56 PM
Excel opens my file and a book1.xls, make it stop? Bob Excel Discussion (Misc queries) 6 January 7th 05 12:20 AM


All times are GMT +1. The time now is 06:28 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017