ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   My excel document is opening two versions. (https://www.excelbanter.com/excel-worksheet-functions/64810-my-excel-document-opening-two-versions.html)

Nikki

My excel document is opening two versions.
 
When I open my spreadsheet, it opens the same document twice. Edits show up
in both documents. How can I stop that?

Bernard Liengme

My excel document is opening two versions.
 
Did you use Windows | New Window before you saved the workbook?
If I do this and reopen the file I get JUNK.XLS.1 and JUNK.XLS.2
IF I close one of these and do a Save, next time I open that file all is
well
Hope this helps
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Nikki" wrote in message
...
When I open my spreadsheet, it opens the same document twice. Edits show
up
in both documents. How can I stop that?




Nikki

My excel document is opening two versions.
 
If I close one, the other closes too. I tried saving and closing, and they
both reopen again.

Thanks for your help though!

"Bernard Liengme" wrote:

Did you use Windows | New Window before you saved the workbook?
If I do this and reopen the file I get JUNK.XLS.1 and JUNK.XLS.2
IF I close one of these and do a Save, next time I open that file all is
well
Hope this helps
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Nikki" wrote in message
...
When I open my spreadsheet, it opens the same document twice. Edits show
up
in both documents. How can I stop that?





Dave Peterson

My excel document is opening two versions.
 
Select the window you don't want and hit ctrl-w.

Then save the workbook.

Nikki wrote:

If I close one, the other closes too. I tried saving and closing, and they
both reopen again.

Thanks for your help though!

"Bernard Liengme" wrote:

Did you use Windows | New Window before you saved the workbook?
If I do this and reopen the file I get JUNK.XLS.1 and JUNK.XLS.2
IF I close one of these and do a Save, next time I open that file all is
well
Hope this helps
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Nikki" wrote in message
...
When I open my spreadsheet, it opens the same document twice. Edits show
up
in both documents. How can I stop that?





--

Dave Peterson

Nikki

My excel document is opening two versions.
 
That worked - thanks!

"Dave Peterson" wrote:

Select the window you don't want and hit ctrl-w.

Then save the workbook.

Nikki wrote:

If I close one, the other closes too. I tried saving and closing, and they
both reopen again.

Thanks for your help though!

"Bernard Liengme" wrote:

Did you use Windows | New Window before you saved the workbook?
If I do this and reopen the file I get JUNK.XLS.1 and JUNK.XLS.2
IF I close one of these and do a Save, next time I open that file all is
well
Hope this helps
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Nikki" wrote in message
...
When I open my spreadsheet, it opens the same document twice. Edits show
up
in both documents. How can I stop that?




--

Dave Peterson



All times are GMT +1. The time now is 10:36 AM.

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