ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Multiple worksheets problem (https://www.excelbanter.com/excel-worksheet-functions/71849-multiple-worksheets-problem.html)

jilldean

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

Bernie Deitrick

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




jilldean

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

Bernie Deitrick

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






All times are GMT +1. The time now is 04:58 AM.

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