Why does focus move to a chart worksheet when Excel opens?

[PaulKraemer]

Hi,
I am using Excel for Microsoft Office 365 MSO (Version 2205 Build 16.0.15225.20028) 32-Bit. I have a workbook that has several different worksheets. I consider one particular worsheet (called "Report") to be of the greatest importance, whereas all other worksheets are of secondary importance. With this being the case, when I send this workbook to someone and they open it, I would like worksheet "Report" to be displayed by default. In the hope of accomplishing this, I made sure that I selected worksheet "Report" (and specifically cell "A1" on this worksheet) before saving and closing the workbook. After doing this, when I re-open the workbook, I see that for a brief instant, worksheet "Report" is displayed and cell "A1" is selected. After no more than 1-2 seconds however, focus is automatically moved to a different worksheet. I was wondering if anyone here could tell me what could cause the focus to move like this?

One thing I should mention is that the worksheet to which focus is moved happens to have a chart on it. This chart gets its data from a different worksheet named "Data". Having set my Formula Calculation Options to "Manual", I do not expect that any formulas should be getting calculated automatically, but I am wondering if focus automatically moving to the worksheet that has a chart might something to with the chart having to read its data to draw the resulting graph?

Any suggestions will be greatly appreciated.

Also asked here Why does focus move to chart worksheet when Excel opens?
Thanks in advance,
Paul

 

[Coding4Fun]

Does the workbook contain any macro's? Possible that a macro is forcing focus to that sheet?

Maybe add a macro to try to force the book to the page you want?

Private Sub Workbook_Open()
Sheets("Report").Activate
End Sub

 

[PaulKraemer]

Hi Coding4Fun,

Thank you for your response. I actually stumbled upon a solution, as I explain at the bottom of this thread....

Why does focus move to chart worksheet when Excel opens? [SOLVED]

Hi, I am using Excel for Microsoft Office 365 MSO (Version 2205 Build 16.0.15225.20028) 32-Bit. I have a workbook that has several different worksheets. I consider one particular worsheet (called "Report") to be of the greatest importance, whereas all other worksheets are of secondary...

www.excelforum.com

I appreciate your help.

Best regards,
Paul