ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Opens copy of workbook (https://www.excelbanter.com/excel-discussion-misc-queries/149771-opens-copy-workbook.html)

Kelli V

Opens copy of workbook
 
Using 2003, on one file, when I open it, it also opens a copy. File names
shows as filename:1 and filename:2. When changes are made to one, changes
made to other. It is driving me nuts . . . . . . why is this happening????

Thanks!

Ron de Bruin

Opens copy of workbook
 
hi Kelli

You have two windows open of the same file

See
http://www.contextures.com/xlfaqApp.html#TwoWindows

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Kelli V" <Kelli wrote in message ...
Using 2003, on one file, when I open it, it also opens a copy. File names
shows as filename:1 and filename:2. When changes are made to one, changes
made to other. It is driving me nuts . . . . . . why is this happening????

Thanks!


David Biddulph[_2_]

Opens copy of workbook
 
It's not 2 copies of the file, but you've opened two windows in the one
workbook.

Close one window with the X *below* the red X in the top right-hand corner.
Then save the file so that it doesn't open the two windows when you next
open the file.
--
David Biddulph

"Kelli V" <Kelli wrote in message
...
Using 2003, on one file, when I open it, it also opens a copy. File names
shows as filename:1 and filename:2. When changes are made to one, changes
made to other. It is driving me nuts . . . . . . why is this
happening????

Thanks!




bj

Opens copy of workbook
 
someone went to windowand selected New window
go to window.Arrange and delete one of the visible dupicates
save and reopen and the duplicate cope will be gone.
being able to have two windows of the same file can be very handy as when
you are comparing things on different sheets, but is definately a headache
when you don't expect it.

"Kelli V" wrote:

Using 2003, on one file, when I open it, it also opens a copy. File names
shows as filename:1 and filename:2. When changes are made to one, changes
made to other. It is driving me nuts . . . . . . why is this happening????

Thanks!


Kelli V[_2_]

Opens copy of workbook
 
I am only opening it once and when I do that . . . both copies open.

"Ron de Bruin" wrote:

hi Kelli

You have two windows open of the same file

See
http://www.contextures.com/xlfaqApp.html#TwoWindows

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Kelli V" <Kelli wrote in message ...
Using 2003, on one file, when I open it, it also opens a copy. File names
shows as filename:1 and filename:2. When changes are made to one, changes
made to other. It is driving me nuts . . . . . . why is this happening????

Thanks!



Ron de Bruin

Opens copy of workbook
 
Read Debra's instructions



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Kelli V" wrote in message ...
I am only opening it once and when I do that . . . both copies open.

"Ron de Bruin" wrote:

hi Kelli

You have two windows open of the same file

See
http://www.contextures.com/xlfaqApp.html#TwoWindows

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Kelli V" <Kelli wrote in message ...
Using 2003, on one file, when I open it, it also opens a copy. File names
shows as filename:1 and filename:2. When changes are made to one, changes
made to other. It is driving me nuts . . . . . . why is this happening????

Thanks!




All times are GMT +1. The time now is 04:09 PM.

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