 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / May 2008Click on first worksheet creates a new workbook automatically
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? > Version: 2008 > Operating System: Mac OS X 10.5 (Leopard) [quoted text clipped - 3 lines] > 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"? 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? > Sorry - travel has kept me from following up on this. > [quoted text clipped - 3 lines] > 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? 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! > 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... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.