Excel 2003 worksheet duplication -not intended
I have an Excel worksheet named (example)Insurance worksheet 2007. When I
opened the worksheet this morning it came up with two(2) worksheets named the same as above, however one was listed as Insurance worksheet 2007:1 and the other Insurance worksheet 2007:2. I looked in restore but there was nothing to restore from the end of the day. The last file saved was at 12:00 PM. I had saved the worksheet at the end of the day (5:00PM) but it didn't show up. It is almost like the Insurance worksheet-2007 was the folder and it held 2 worksheets, but that is not the case. Help! |
Excel 2003 worksheet duplication -not intended
A new window was created.
Go to Window - Arrange. Pick vertical, and then close one of the panes. You normally use that feature when doing a comparison, or if you want to do an Alt-Tab combo, but switch between sheets in the same workbook. -- Best Regards, Luke M "Joan" wrote: I have an Excel worksheet named (example)Insurance worksheet 2007. When I opened the worksheet this morning it came up with two(2) worksheets named the same as above, however one was listed as Insurance worksheet 2007:1 and the other Insurance worksheet 2007:2. I looked in restore but there was nothing to restore from the end of the day. The last file saved was at 12:00 PM. I had saved the worksheet at the end of the day (5:00PM) but it didn't show up. It is almost like the Insurance worksheet-2007 was the folder and it held 2 worksheets, but that is not the case. Help! |
Excel 2003 worksheet duplication -not intended
It's not 2 worksheets, it's 2 windows open on the same worksheet. [You get
in that situation by Window/ New Window, or Alt-W-N.] Close one with the blue X, not the red X above it in the top right-hand corner. Save and reopen and you should see only the one window. -- David Biddulph "Joan" wrote in message ... I have an Excel worksheet named (example)Insurance worksheet 2007. When I opened the worksheet this morning it came up with two(2) worksheets named the same as above, however one was listed as Insurance worksheet 2007:1 and the other Insurance worksheet 2007:2. I looked in restore but there was nothing to restore from the end of the day. The last file saved was at 12:00 PM. I had saved the worksheet at the end of the day (5:00PM) but it didn't show up. It is almost like the Insurance worksheet-2007 was the folder and it held 2 worksheets, but that is not the case. Help! |
All times are GMT +1. The time now is 12:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com