ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Opens two files (https://www.excelbanter.com/excel-discussion-misc-queries/72689-excel-opens-two-files.html)

lara5555

Excel Opens two files
 

Hey there,

Recently when I open a excel file from Lotus Notes it opens up two
versions such as filename:1 and filename:2

This has become quite annoying as its hard to use the compare side by
side option as I always have to chose which file.

Can anyone help save me 5 seconds of my time? Qutie important as I
have about 60 files to compare and it gets annoying having to keep
close one down.

Thanks :)


--
lara5555
------------------------------------------------------------------------
lara5555's Profile: http://www.excelforum.com/member.php...fo&userid=2741
View this thread: http://www.excelforum.com/showthread...hreadid=514344


Dave Peterson

Excel Opens two files
 
I don't think that this is a Lotus Notes problem--but I've never used Notes.

My bet is that the person who sent the file had two windows open to the same
workbook and saved it that way.

You can close the window you don't want by:
selecting that window
ctrl-w

(save the file--or you'll have to do it again).

This is caused by using Window|New Window (and maybe window|arrange to make it
useful). If you use this, you can tile the windows so you can see different
parts of the workbook (or even the same worksheet) without having to swap back
and forth--or do lots of scrolling.

lara5555 wrote:

Hey there,

Recently when I open a excel file from Lotus Notes it opens up two
versions such as filename:1 and filename:2

This has become quite annoying as its hard to use the compare side by
side option as I always have to chose which file.

Can anyone help save me 5 seconds of my time? Qutie important as I
have about 60 files to compare and it gets annoying having to keep
close one down.

Thanks :)

--
lara5555
------------------------------------------------------------------------
lara5555's Profile: http://www.excelforum.com/member.php...fo&userid=2741
View this thread: http://www.excelforum.com/showthread...hreadid=514344


--

Dave Peterson


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

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