ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shadow/duplicate excel file .xls:2 (https://www.excelbanter.com/excel-discussion-misc-queries/31998-shadow-duplicate-excel-file-xls-2-a.html)

Courtney

Shadow/duplicate excel file .xls:2
 
I have a shadow excel file (extension ".xls:2") that opens everytime I open
my original file. The original file shows in Windows Explorer as extension
".xls" but when I open it, the extension displays as ".xls:1" and the shadow
copy opens at the same time.

The shadow copy is not to be found anywhere in Windows explorer. I have no
hidden files or extensions and I've searched for "*.xls:2" with none found.

The shadow/duplicate copy mirrors every change made to the original file.

Gord Dibben

Courtney

It is not an extra file, just an extra window.

You have two Windows open with the same worksheet.

Someone inadverantly created a window using WindowNew Window.

Close one of them using the "x" then save the workbook.

This is a handy feature if you want to look at two or more sheets/books at a
time or two or more views of the same sheet/book.


Gord Dibben Excel MVP


On Wed, 22 Jun 2005 14:33:03 -0700, "Courtney"
wrote:

I have a shadow excel file (extension ".xls:2") that opens everytime I open
my original file. The original file shows in Windows Explorer as extension
".xls" but when I open it, the extension displays as ".xls:1" and the shadow
copy opens at the same time.

The shadow copy is not to be found anywhere in Windows explorer. I have no
hidden files or extensions and I've searched for "*.xls:2" with none found.

The shadow/duplicate copy mirrors every change made to the original file.



Gord Dibben

Someone also typoed a word.

"inadvertently" is more better<g


Gord

On Wed, 22 Jun 2005 14:50:41 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Courtney

It is not an extra file, just an extra window.

You have two Windows open with the same worksheet.

Someone inadverantly created a window using WindowNew Window.

Close one of them using the "x" then save the workbook.

This is a handy feature if you want to look at two or more sheets/books at a
time or two or more views of the same sheet/book.


Gord Dibben Excel MVP


On Wed, 22 Jun 2005 14:33:03 -0700, "Courtney"
wrote:

I have a shadow excel file (extension ".xls:2") that opens everytime I open
my original file. The original file shows in Windows Explorer as extension
".xls" but when I open it, the extension displays as ".xls:1" and the shadow
copy opens at the same time.

The shadow copy is not to be found anywhere in Windows explorer. I have no
hidden files or extensions and I've searched for "*.xls:2" with none found.

The shadow/duplicate copy mirrors every change made to the original file.



Courtney

Thank you - this was actually for a co-worker. But I couldn't figure out
what she did. That would come in handy for viewing a large spreadsheet.

"Gord Dibben" wrote:

Someone also typoed a word.

"inadvertently" is more better<g


Gord

On Wed, 22 Jun 2005 14:50:41 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Courtney

It is not an extra file, just an extra window.

You have two Windows open with the same worksheet.

Someone inadverantly created a window using WindowNew Window.

Close one of them using the "x" then save the workbook.

This is a handy feature if you want to look at two or more sheets/books at a
time or two or more views of the same sheet/book.


Gord Dibben Excel MVP


On Wed, 22 Jun 2005 14:33:03 -0700, "Courtney"
wrote:

I have a shadow excel file (extension ".xls:2") that opens everytime I open
my original file. The original file shows in Windows Explorer as extension
".xls" but when I open it, the extension displays as ".xls:1" and the shadow
copy opens at the same time.

The shadow copy is not to be found anywhere in Windows explorer. I have no
hidden files or extensions and I've searched for "*.xls:2" with none found.

The shadow/duplicate copy mirrors every change made to the original file.





All times are GMT +1. The time now is 06:25 AM.

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