Click on first worksheet creates a new workbook automatically

[sac_mac]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Every time I create a new second worksheet, add data to it, and click back to the first worksheet, i get a new workbook created replicating the first worksheet. Is this by design?

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Every time I create a new second worksheet, add data to it, and click back to
the first worksheet, i get a new workbook created replicating the first
worksheet. Is this by design?

Decidedly not.

How are you "click(ing) back"? Clicking on the Tab? Via the Window menu?

Are you possibly getting a new window into the original workbook (i.e.,
the workbook title bar shows "WorkbookName.xls:1"?

 

[sac_mac]

Sorry - travel has kept me from following up on this.

The progression would be this:

I create a new workbook (workbook1), name the first worksheet tab "Test". I click on the second worksheet's tab. Enter data. Click back to the first tab (Test) and a new workbook shows on the screen entitled "workbook2."

Any ideas?

 

[JE McGimpsey]

Sorry - travel has kept me from following up on this.

The progression would be this:

I create a new workbook (workbook1), name the first worksheet tab "Test". I
click on the second worksheet's tab. Enter data. Click back to the first tab
(Test) and a new workbook shows on the screen entitled "workbook2."

If you're clicking on the worksheet "Test" tab at the bottom of the
window, you've got me stumped. I can't think of a way to reproduce this.

Does the same thing happen if you use CMD-Page Up to switch sheets? Or
if you right-click on the Sheet Selection control (to the left of the
worksheet tabs) and choose sheet "Test"

Does it happen if you start XL with the shift key down?

 

[sac_mac]

WOW! I got it solved, but it was TOTALLY crazy. Forever, i have had my formula setting at the bottom of the worksheep, hovering just above the sheet tabs. Apparently, something about the focus was throwing off the behavior of the worksheet tabs causing a click on the first one to produce the new worksheet.

Now worries . . . i just moved the formula bar.

Thanks for the time, however!

 

[JE McGimpsey]

WOW! I got it solved, but it was TOTALLY crazy. Forever, i have had my
formula setting at the bottom of the worksheep, hovering just above the sheet
tabs. Apparently, something about the focus was throwing off the behavior of
the worksheet tabs causing a click on the first one to produce the new
worksheet.

Glad you got it sorted. I've never used the formula bar at the bottom.
Strange...