Make a particular worksheet the default whenever the file is opened??

%3CLINGO-SUB%20id%3D%22lingo-sub-2544362%22%20slang%3D%22en-US%22%3EMake%20a%20particular%20worksheet%20the%20default%20whenever%20the%20file%20is%20opened%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2544362%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello!%20I%20have%20a%20shared%20Excel%20doc%20online%2C%20used%20by%20multiple%20people.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIt%20has%20two%20worksheets%20%E2%80%94%20one%20with%20the%20majority%20of%20the%20data%20which%20would%20be%20used%20most%20often%2C%20and%20a%20second%20one%20that%20is%20necessary%20but%20far%20less%20frequently%20accessed.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EInexplicably%2C%20anytime%20we%20open%20the%20file%2C%20it%20opens%20to%20the%20second%20worksheet.%20Some%20users%20aren%E2%80%99t%20so%20adept%20at%20choosing%20the%20correct%20one%2C%20so%20I%20need%20to%20make%20the%20first%20one%20the%20default%20upon%20opening.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EHow%20can%20I%20define%20the%20MAIN%20worksheet%20as%20the%20DEFAULT%20worksheet%2C%20whenever%20someone%20accesses%20the%20file%20online%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2544362%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello! I have a shared Excel doc online, used by multiple people.

 

It has two worksheets — one with the majority of the data which would be used most often, and a second one that is necessary but far less frequently accessed.

 

Inexplicably, anytime we open the file, it opens to the second worksheet. Some users aren’t so adept at choosing the correct one, so I need to make the first one the default upon opening.

 

How can I define the MAIN worksheet as the DEFAULT worksheet, whenever someone accesses the file online?

0 Replies