Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jilldean
 
Posts: n/a
Default Multiple worksheets problem


Hi There - hope somebody can help.

One of our users has accidently done something on his excel
spreadsheet. This has caused a problem where when you open a workbook
called eg workbook1, it opens up 2 more copies called workbbok 2 and
workbook 3 in the taskbar. not sure how to get rid of the extra two
copies, or why they are there in the first place. If I rename the
spreadsheet to new.xls, the other two change to new2 and new3.

Many Thanks

Jill


--
jilldean
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick
 
Posts: n/a
Default Multiple worksheets problem

Jill,

Sounds like they have multiple windows of the same workbook. Open the file, then close "2" and "3"
using the window's "x" button at the upper right, and then save the file.

HTH,
Bernie
MS Excel MVP


"jilldean" wrote in message
...

Hi There - hope somebody can help.

One of our users has accidently done something on his excel
spreadsheet. This has caused a problem where when you open a workbook
called eg workbook1, it opens up 2 more copies called workbbok 2 and
workbook 3 in the taskbar. not sure how to get rid of the extra two
copies, or why they are there in the first place. If I rename the
spreadsheet to new.xls, the other two change to new2 and new3.

Many Thanks

Jill


--
jilldean



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jilldean
 
Posts: n/a
Default Multiple worksheets problem


Thanks Bernie that worked perfectly

Jill

Bernie Deitrick Wrote:
Jill,

Sounds like they have multiple windows of the same workbook. Open the
file, then close "2" and "3"
using the window's "x" button at the upper right, and then save the
file.

HTH,
Bernie
MS Excel MVP


"jilldean" wrote in message
...

Hi There - hope somebody can help.

One of our users has accidently done something on his excel
spreadsheet. This has caused a problem where when you open a
workbook
called eg workbook1, it opens up 2 more copies called workbbok 2 and
workbook 3 in the taskbar. not sure how to get rid of the extra two
copies, or why they are there in the first place. If I rename the
spreadsheet to new.xls, the other two change to new2 and new3.

Many Thanks

Jill


--
jilldean



--
jilldean
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick
 
Posts: n/a
Default Multiple worksheets problem

Jill,

You're quite welcome. Thanks for letting us know that it worked out OK.

Bernie
MS Excel MVP

Thanks Bernie that worked perfectly




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the quickest method to insert & name multiple worksheets . clyonesse Excel Worksheet Functions 8 September 20th 05 10:55 PM
Printing Multiple Worksheets Linda Excel Discussion (Misc queries) 1 August 8th 05 05:12 PM
Help with countif on multiple worksheets jeremed Excel Worksheet Functions 2 July 8th 05 12:59 AM
Adding multiple worksheets Craig Excel Worksheet Functions 1 July 6th 05 07:21 PM
Extracting data from multiple worksheets into a list mnirula Excel Worksheet Functions 16 February 25th 05 08:52 PM


All times are GMT +1. The time now is 09:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"