ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel opens two copies of spreadsheets (https://www.excelbanter.com/excel-discussion-misc-queries/94154-excel-opens-two-copies-spreadsheets.html)

docwatson

excel opens two copies of spreadsheets
 
When we open a certain spread sheet on workstation from a file server it
opens 2 copies. Happens with multiple users. Any entry made on one copy is
reflected on the other. There is only one copy on the server. Server is
running Windows 2003, workstations XP/ Office 2003.

Dave Peterson

excel opens two copies of spreadsheets
 
Could it be two windows of the same workbook?

http://contextures.com/xlfaqApp.html#TwoWindows
(From Debra Dalgleish's site)

docwatson wrote:

When we open a certain spread sheet on workstation from a file server it
opens 2 copies. Happens with multiple users. Any entry made on one copy is
reflected on the other. There is only one copy on the server. Server is
running Windows 2003, workstations XP/ Office 2003.


--

Dave Peterson

docwatson

excel opens two copies of spreadsheets
 
They open in separate window the first named "spreadsheetname.1.xls", and the
second named "spreadsheetname.2.xls". It doesn't happen everytime. We have
many of these spreadsheets generated off a common template. We don't see the
problem when opening the template. Just often when we open a copy that has
had data entered in it.

"Dave Peterson" wrote:

Could it be two windows of the same workbook?

http://contextures.com/xlfaqApp.html#TwoWindows
(From Debra Dalgleish's site)

docwatson wrote:

When we open a certain spread sheet on workstation from a file server it
opens 2 copies. Happens with multiple users. Any entry made on one copy is
reflected on the other. There is only one copy on the server. Server is
running Windows 2003, workstations XP/ Office 2003.


--

Dave Peterson


Dave Peterson

excel opens two copies of spreadsheets
 
Are you sure that what you see isn't more like:

spreadsheetname1.xls:1
and
spreadsheetname1.xls:2

If it is like this, read that link to learn how to close one of those windows
and then save the workbook that way--else you'll be doing it again.

docwatson wrote:

They open in separate window the first named "spreadsheetname.1.xls", and the
second named "spreadsheetname.2.xls". It doesn't happen everytime. We have
many of these spreadsheets generated off a common template. We don't see the
problem when opening the template. Just often when we open a copy that has
had data entered in it.

"Dave Peterson" wrote:

Could it be two windows of the same workbook?

http://contextures.com/xlfaqApp.html#TwoWindows
(From Debra Dalgleish's site)

docwatson wrote:

When we open a certain spread sheet on workstation from a file server it
opens 2 copies. Happens with multiple users. Any entry made on one copy is
reflected on the other. There is only one copy on the server. Server is
running Windows 2003, workstations XP/ Office 2003.


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 10:11 PM.

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