Microsoft Tech Community Live:  Microsoft Teams Edition
November 09, 2021, 08:00 AM - 12:00 PM (PST)

Excel file with drop-down takes long to preview or edit in Teams and Excel Online

%3CLINGO-SUB%20id%3D%22lingo-sub-511358%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20file%20with%20drop-down%20takes%20long%20to%20preview%20or%20edit%20in%20Teams%20and%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-511358%22%20slang%3D%22en-US%22%3E%3CP%3EShould%20I%20post%20this%20topic%20somewhere%20else%3F%20No%20one%20else%20having%20this%20issue%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-497210%22%20slang%3D%22en-US%22%3EExcel%20file%20with%20drop-down%20takes%20long%20to%20preview%20or%20edit%20in%20Teams%20and%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-497210%22%20slang%3D%22en-US%22%3E%3CP%3ECreated%20an%20Excel%20spreadsheet%20with%203%20tabs%2C%20the%20main%20sheet%20has%20181%20rows.%203%20columns%20in%20the%20main%20sheet%20use%20Data%20Validation%20to%20populate%20drop-down%20menus%20for%20selection.%3C%2FP%3E%3CP%3EAfter%20I%20uploaded%20the%20files%20to%20Teams%20for%20sharing%20it%20takes%20a%20couple%20minutes%20to%20load%20the%20spreadsheet%20for%20a%20preview.%26nbsp%3B%20If%20you%20try%20to%20edit%20the%20file%20in%20Teams%20or%20Edit%20in%20Excel%20Online%20it%20also%20has%20long%20load%20times.%3C%2FP%3E%3CP%3EI%20have%20tried%20the%20following%3A%3C%2FP%3E%3CP%3EUse%20Teams%20app%20to%20preview%20%2F%20edit%20file%3C%2FP%3E%3CP%3EUse%20Chrome%2FEdge%20to%20open%20file%20in%20Teams%20online%20for%26nbsp%3B%3CSPAN%3Epreview%20%2F%20edit%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EUse%20Chrome%2FEdge%20to%20open%20file%20in%20Excel%20Online%20for%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Epreview%20%2F%20edit%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EOpen%20the%20file%20on%20the%20SharePoint%20drive%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20above%20didn't%20help%20load%20times.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EAfter%20I%20remove%20the%20Data%20Validation%20drop-downs%20the%20spreadsheet%20opens%20much%20faster%20using%20the%20web%20options%20and%20desktop%20app%20(similar%20to%20other%20spreadsheets)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20spreadsheet%20loading%20issue%20is%20not%20present%20when%20I%20open%20the%20file%20off%20the%20hard%20drive%20of%20my%20desktop%20computer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIs%20this%20a%20known%20issue%2Fbug%3F%20I%20would%20really%20like%20to%20use%20the%20drop%20downs%26nbsp%3Bfor%20data%20consistency.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E****update****%26nbsp%3B%205%2F1%2F2019%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Eno%20replies%20so%20I%20have%20attached%20a%20couple%20files%20for%20your%20testing.%20Upload%20these%20files%20to%20a%20team%20and%20try%20to%20view%2Fedit%2C%20do%20you%20see%20the%20load%20issue%20with%26nbsp%3Bwith%20drop-down%20-%20slow%20load.xlsx%20compared%20to%26nbsp%3Bno%20drop-down%20-%20faster%20load.xlsx%3F%20This%20is%20a%20bug%2C%20yeah%3F%20To%20be%20fixed%3F%20Need%20Teams%20to%20open%2Fedit%20office%20files%20similar%20to%20my%20desktop%20software.%20The%20main%20issue%20is%20initial%20load%20time%2C%20however%20if%20you%20leave%20the%20file%20open%20for%20awhile%20and%20try%20to%20scroll%2C%20the%20data%20has%20to%20reload%20again.%20Makes%20drop-down%20selection%20unusable%20in%20excel%20online%20in%20my%20opinion.%26nbsp%3B%20Please%20advise.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EUsing%20free%20Teams%20accounts.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%2C%20Chris%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-497210%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-969308%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20file%20with%20drop-down%20takes%20long%20to%20preview%20or%20edit%20in%20Teams%20and%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-969308%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F329360%22%20target%3D%22_blank%22%3E%40cmayo%3C%2FA%3E%26nbsp%3BI%20have%20same%20issue%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Created an Excel spreadsheet with 3 tabs, the main sheet has 181 rows. 3 columns in the main sheet use Data Validation to populate drop-down menus for selection.

After I uploaded the files to Teams for sharing it takes a couple minutes to load the spreadsheet for a preview.  If you try to edit the file in Teams or Edit in Excel Online it also has long load times.

I have tried the following:

Use Teams app to preview / edit file

Use Chrome/Edge to open file in Teams online for preview / edit

Use Chrome/Edge to open file in Excel Online for preview / edit

Open the file on the SharePoint drive

 

The above didn't help load times.

After I remove the Data Validation drop-downs the spreadsheet opens much faster using the web options and desktop app (similar to other spreadsheets)

This spreadsheet loading issue is not present when I open the file off the hard drive of my desktop computer.

 

Is this a known issue/bug? I would really like to use the drop downs for data consistency.

 

****update****  5/1/2019

no replies so I have attached a couple files for your testing. Upload these files to a team and try to view/edit, do you see the load issue with with drop-down - slow load.xlsx compared to no drop-down - faster load.xlsx? This is a bug, yeah? To be fixed? Need Teams to open/edit office files similar to my desktop software. The main issue is initial load time, however if you leave the file open for awhile and try to scroll, the data has to reload again. Makes drop-down selection unusable in excel online in my opinion.  Please advise.

 

Using free Teams accounts.

Thanks, Chris

 

3 Replies

Should I post this topic somewhere else? No one else having this issue? 

@cmayo & @naim2601 i know this thread is old, but did you ever get this resolved? I am seeing the same issue.