Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel97--Accidentally opened New Window Don't want book1:1!

Status
Not open for further replies.
MrsTFB

MrsTFB

MIS
Oct 3, 2000
307
US
Help!

I accidentally pushed the Window and New Window in a spreadsheet. Now I have 3 copies of my workbook. When I close and reopen, I still have all windows.

I think someone knows how to fix this, WHO??!!

Thanks for helping,
Bsimm

 
Sort by date Sort by votes
While viewing the workbook, click the X in the right corner of the viewpane. (Do NOT click the X to close Excel.)

Your extra windows, (the :2, :3 versions) should go away.

When this happened to me the first time it was very frustrating !!!
 
Upvote 0 Downvote
Hey Thanks,
That was exactly what I needed to know. I had closed the workbook, but not with the X.


Bsimm
I love this website!!

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
Extract lines from table into new table
Replies
2
Views
355
SkipVought
S
Metzke
  • Locked
  • Question
How to Transfer Licence to New PC
Replies
11
Views
398
teknance
teknance
ladyck3
  • Locked
  • Question
Excel An occurance on Sheet #1 - from A:A - want to find the total of $ in G:G ... on Sheet 2 6
Replies
14
Views
228
SkipVought
S
ladyck3
  • Locked
  • Question
EXCEL - I'm starting a new project but have to say... to all...
Replies
2
Views
153
ladyck3
ladyck3
Rick_Stanich
  • Locked
  • Question
Save active Excel file to new location
Replies
6
Views
131
Rick_Stanich
Rick_Stanich

Part and Inventory Search

Sponsor

Back
Top