Moving from Excel sheet to sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-3218038%22%20slang%3D%22en-US%22%3EMoving%20from%20Excel%20sheet%20to%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3218038%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20open%20an%20Excel%20file%20with%20multiple%20sheets%2C%20I%20cannot%20move%20to%20any%20sheet%20other%20than%20the%20one%20that%20is%20active%20when%20I%20open%20the%20file.%26nbsp%3B%20What%20is%20the%20problem%3F%26nbsp%3B%20I%20am%20using%20Office%202016%20and%20have%20been%20able%20to%20move%20to%20any%20sheet%20of%20choice%20as%20recent%20as%202%2F17%2F2022.%26nbsp%3B%20I%20use%20OneDrive.%26nbsp%3B%20Have%20not%20changed%20anything%20to%20my%20knowledge%20since%202%2F17%2F22%20to%20affect%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3218038%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3218048%22%20slang%3D%22en-US%22%3ERe%3A%20Moving%20from%20Excel%20sheet%20to%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3218048%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1319015%22%20target%3D%22_blank%22%3E%40Rose_Kile%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EClicking%20on%20another%20sheet%20tab%20doesn't%20do%20anything%3F%20And%20neither%20does%20pressing%20Ctrl%2BPgUp%20or%20Ctrl%2BPgDn%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3218249%22%20slang%3D%22en-US%22%3ERe%3A%20Moving%20from%20Excel%20sheet%20to%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3218249%22%20slang%3D%22en-US%22%3ECorrect%2C%20no%20to%20all%20your%20questions.%20The%20usual%20doesn't%20work.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3218257%22%20slang%3D%22en-US%22%3ERe%3A%20Moving%20from%20Excel%20sheet%20to%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3218257%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1319015%22%20target%3D%22_blank%22%3E%40Rose_Kile%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%20the%20following%3A%3C%2FP%3E%0A%3CP%3EClose%20all%20workbooks%20so%20that%20Excel%20is%20no%20longer%20active.%3C%2FP%3E%0A%3CP%3EHold%20down%20the%20left%20Ctrl%20key%20while%20you%20start%20Excel%20again.%3C%2FP%3E%0A%3CP%3EYou%20should%20see%20this%20prompt%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S1182.png%22%20style%3D%22width%3A%20413px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351520iBD3E0FC87D04B8C4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S1182.png%22%20alt%3D%22S1182.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EClick%20Yes.%3C%2FP%3E%0A%3CP%3ENow%20open%20a%20workbook%20with%20multiple%20sheets%20from%20within%20Excel.%3C%2FP%3E%0A%3CP%3ECan%20you%20switch%20to%20another%20worksheet%20now%2C%20or%20is%20it%20still%20impossible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

When I open an Excel file with multiple sheets, I cannot move to any sheet other than the one that is active when I open the file.  What is the problem?  I am using Office 2016 and have been able to move to any sheet of choice as recent as 2/17/2022.  I use OneDrive.  Have not changed anything to my knowledge since 2/17/22 to affect Excel.

9 Replies

@Rose_Kile 

Clicking on another sheet tab doesn't do anything? And neither does pressing Ctrl+PgUp or Ctrl+PgDn?

Correct, no to all your questions. The usual doesn't work.

@Rose_Kile 

Try the following:

Close all workbooks so that Excel is no longer active.

Hold down the left Ctrl key while you start Excel again.

You should see this prompt:

S1182.png

Click Yes.

Now open a workbook with multiple sheets from within Excel.

Can you switch to another worksheet now, or is it still impossible?

I could move to the last sheet of 5 but can't go to any other sheet, not even the 1 sheet that was active when I opened Excell in safe mode. Thanks for trying to help me.

@Rose_Kile 

Does this happen in all workbooks with more than one worksheet? If so, it would appear that there is something wrong with your installation of Office - try repairing it.

@Rose_Kile 

With permission of all involved, I recommend to provide more information.

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

Please inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

If possible, add photos and describe your issue step by step, with the appropriate description.

Don't forget that…what you see we can't see :).

 

Questions that arise in your description:

Are both files in OneDrive?

If not, is OneDrive synced to your PC?

Are they excel files that have different formats?

Does it happen with all excel files in OneDrive?

Did you do an update beforehand?

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

I solved my problem by unstalling Microsoft Office, reinstalling, and activating. Now I can move from sheet to sheet. However, I don't understand what happened between 2/17 and 2/27/22 that caused me not to be able to move from sheet to sheet.

@Rose_Kile 

Excel must have become corrupted somehow. Gremlins? Cosmic radiation? We'll never know...

You are right, I will never know because my anti-virus software never reported any issues. In fact, it always reported nothing found.