Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel auto jump worksheets when open
Hi, hope someone can help me.
I open a shared workbooks which has 10 worksheets inside. Then i made some changes to a specific worksheet named "projects" and close the workbook after saving. The next time when i re-open the workbook, excel, will auto jump to the worksheet which previously saved "projects", eventhough other users have made the changes in other worksheet "pricing", save the file and closed. Please help, it has come to a point where excel is lagging when i open that workbook. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel auto jump worksheets when open
some questions:
- does excel ask you for permission to enable macros when you open the file? there could be a macro there which activates that sheet when the file is opened (or just before it is closed) - check with the other users to see if it is just you that has this problem or if it also jumps to that sheet for them. -- Allllen "belleaura" wrote: Hi, hope someone can help me. I open a shared workbooks which has 10 worksheets inside. Then i made some changes to a specific worksheet named "projects" and close the workbook after saving. The next time when i re-open the workbook, excel, will auto jump to the worksheet which previously saved "projects", eventhough other users have made the changes in other worksheet "pricing", save the file and closed. Please help, it has come to a point where excel is lagging when i open that workbook. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel auto jump worksheets when open
Hi Allllen,
answers to your questions: no, excel, doesnt ask for permission to enable macros. i checked with my other colleagues, apparently excel did the same for them as well. only that excel will jump to the worksheet that was last save by them. "Allllen" wrote: some questions: - does excel ask you for permission to enable macros when you open the file? there could be a macro there which activates that sheet when the file is opened (or just before it is closed) - check with the other users to see if it is just you that has this problem or if it also jumps to that sheet for them. -- Allllen "belleaura" wrote: Hi, hope someone can help me. I open a shared workbooks which has 10 worksheets inside. Then i made some changes to a specific worksheet named "projects" and close the workbook after saving. The next time when i re-open the workbook, excel, will auto jump to the worksheet which previously saved "projects", eventhough other users have made the changes in other worksheet "pricing", save the file and closed. Please help, it has come to a point where excel is lagging when i open that workbook. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-jump to another cell | Excel Discussion (Misc queries) | |||
Ctrl+pgup pgdn can't jump worksheets | Excel Worksheet Functions | |||
how do i enfoce a"auto-tab or jump" to next cell | Excel Discussion (Misc queries) | |||
how do I auto name worksheets in Excel? | Excel Worksheet Functions | |||
How do I set Excel to auto open a document into a new Window even. | Excel Worksheet Functions |