Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How do I delete a second version of a spreadsheet

I have a couple of spreadsheets that, when opened, show 2 versions of the
same spreadsheet. However, it is only listed once in that folder.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default How do I delete a second version of a spreadsheet

You've got two windows open. Close one of the windows (the X in the top
right-hand corner of the sheet, but not the big red X above it for closing
the whole of Excel down), then save the workbook and reopen.
--
David Biddulph

"Bizwiz" wrote in message
...
I have a couple of spreadsheets that, when opened, show 2 versions of the
same spreadsheet. However, it is only listed once in that folder.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How do I delete a second version of a spreadsheet

Do you see:

book1.xls:1
and
book2.xls:2

If you do then this isn't really two copies of the workbook. It's just two
views (or windows) into the same workbook.

You can select the window you don't want to see, then hit ctrl-w to close that
window.

Then save the workbook or you'll be doing it again!

Debra Dalgleish has some instructions with pictures:
http://contextures.com/xlfaqApp.html#TwoWindows

This can be caused by using:
Window|New window
(in xl2003 menus)
(maybe followed by window|arrange)

It can be quite useful to see different ares of the same workbook (even same
worksheet) at the same time.

Bizwiz wrote:

I have a couple of spreadsheets that, when opened, show 2 versions of the
same spreadsheet. However, it is only listed once in that folder.


--

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
Can i get a previously saved version of an excel spreadsheet? ltcbas3 Excel Discussion (Misc queries) 1 November 3rd 08 04:28 PM
Removing Tabs in Web Page version of Spreadsheet Rodman Excel Discussion (Misc queries) 0 August 28th 07 03:02 PM
how can i send a static version of a linked spreadsheet Liam C Excel Discussion (Misc queries) 3 June 28th 07 10:07 PM
save a spreadsheet file with same name but different version ASDonnelly New Users to Excel 1 April 13th 06 09:27 AM
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? oil_driller Excel Discussion (Misc queries) 1 February 8th 05 09:34 AM


All times are GMT +1. The time now is 04:16 AM.

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

About Us

"It's about Microsoft Excel"