Worksheet opens twice


Posted by Duane on November 26, 2001 1:59 PM

I have a worksheet created in Excel 97 which opens twice everytime I open it. It happens all at once and unless you pay attention to the title bar with ends with :2 you won't notice it is open twice. It also shows twice if I look under the window menu. If I close the :2 copy the other stays open. This document is used over a network at the same thing happens on every pc so I belive the doccumant is the problem.

Thanks



Posted by jacob on November 26, 2001 2:16 PM

In Excel on the Window menu there is a new window command. That makes the second window so you have workbook:1 and workbook:2. If you close workbook:2 and then save the next time you open there should only be one workbook. I just tried it on excel2000 and it worked but Im not 100% sure for excel97. Hope this helps.

Jacob