Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel defaults back to 1st Worksheet
When I am opening Excel, it is reverting back to worksheet 1 even when I
saved on worksheet 10. I am using Excel 2000 v.2.2 I need it to open on the last worksheet worked on. |
#2
|
|||
|
|||
Hi
you might need to see if there is any code running in your workbook - right mouse click on a sheet tab, choose view code - on the left hand side of the screen in the project explorer (if you can't see it choose view / project explorer) you should see your workbook name in bold & brackets, under that all your sheets and then something called "This Workbook" - double click on here and if there's code causing it to default back to sheet1 it will most likely appear on the right hand side of the screen ... you can then delete it or whatever. If you need help deciphering anything that appears on the right - just copy & paste it into a return post. Cheers JulieD "okiegrl" wrote in message ... When I am opening Excel, it is reverting back to worksheet 1 even when I saved on worksheet 10. I am using Excel 2000 v.2.2 I need it to open on the last worksheet worked on. |
#3
|
|||
|
|||
Hello -
It seems that this only happens when the workbook is saved as a shared workbook, but not when shared is removed. When opening the project explorer when it is shared, it comes up with an error stating project unviewable. Any thoughts? Cindy "JulieD" wrote: Hi you might need to see if there is any code running in your workbook - right mouse click on a sheet tab, choose view code - on the left hand side of the screen in the project explorer (if you can't see it choose view / project explorer) you should see your workbook name in bold & brackets, under that all your sheets and then something called "This Workbook" - double click on here and if there's code causing it to default back to sheet1 it will most likely appear on the right hand side of the screen ... you can then delete it or whatever. If you need help deciphering anything that appears on the right - just copy & paste it into a return post. Cheers JulieD "okiegrl" wrote in message ... When I am opening Excel, it is reverting back to worksheet 1 even when I saved on worksheet 10. I am using Excel 2000 v.2.2 I need it to open on the last worksheet worked on. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I faxed an excel worksheet and now cannot print? | Excel Worksheet Functions | |||
Starting MS Excel with a worksheet other than SHEET 1 | Excel Worksheet Functions | |||
Why does an excel worksheet default to 24 copies when printing | Excel Worksheet Functions | |||
How do I replace a worksheet with another worksheet in excel | Excel Worksheet Functions | |||
How do I show the last saved date in an Excel worksheet? | Excel Worksheet Functions |