Strange......

G

Gary Thomson

Hi,

I recently received a document from an external source
which, upon opening, done something I have never seen
happen before - it opens the same file twice, with one
ending in "Issue: 1" and the other ending in "Issue: 2";

i.e. the file's name is "Schools", and when I click on the
icon to open it, I get two files opening on my screen:

"Schools Issue: 1"; and
"Schools Issue: 2".

Even more strange is that when I alter the formats or cell
contents in one of the files, the other is automatically
updated!!

Normally I would just overlook this, but I am fairly
worried as I have to do a complete audit of the file, and
my company has received several DRAFTS of this file
previously which all contained faults (and none of which
opened up in 2 files).

Many thanks for any comments,

Gary.
 
A

Andy B

Hi

We've had this already on this forum today!! Whoever sent you the file had
saved it while two windows of it were open at once (hence :1 and :2). Just
close one and save.
 
H

Hari

Hi,

I have something to add ( rather a query) for this multiple window feature.

Initially I have lets say only one window open and within that some
worksheets have FREEZE panes and they might also have only 75 or 80 % zoom.

Now, If I open a new window of this workbook then the new window doesnt have
freeze panes and also have the default 100% zoom for the respective
worksheets. Suppose I keep on doing lot of editing and if I close the "Hari
: 1" and then work further on "Hari : 2" ( which now changes to "Hari") then
one ends up losing the personalised settings mentioned above for ever.

Why does this happen? Any workaround to this. ( I know that if I close
"Hari:2" and then work on "Hari:1" then my settings in "Hari:1" wont be
lost. But consider this. Suppose I have settings in Hari:1 and when I opened
Hari:2, I might start creating some settings in "Hari:2" in those worksheets
which didnt have already so at the end I will decide between choosing which
of the 2 settings to be lost.)

Did MS intend to not have an exact replica of the workbook/sheet in cases of
multiple windows.

Regards,
Hari
India
 
G

Gord Dibben

Hari

Multiple windows are not necessarily used for working on two views of the same
worksheet.

You can have several workbooks or applications open in multiple windows.

You could have several worksheets open.

Also have views of different areas of the same worksheet.

Window options are a property of the window, not the worksheet or workbook.

Gord Dibben Excel MVP
 
Top