Performance issue when two or more tables are included in the same sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2379447%22%20slang%3D%22en-US%22%3EPerformance%20issue%20when%20two%20tables%20are%20there%20in%20the%20same%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2379447%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20any%20known%20performance%20issues%20when%20there%20are%20two%20or%20more%20tables%20in%20a%20same%20sheet%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhenever%20I%20have%20more%20than%201%20table%20in%20the%20same%20sheet%20then%20system%20takes%20a%20long%20time%20to%20insert%20rows%20or%20columns%20in%20those%20sheets.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20try%20to%20avoid%20having%20multiple%20tables%20in%20one%20sheet.%20But%20from%20a%20user%20experience%20perspective%20sometimes%20when%20each%20of%20the%20tables%20are%20too%20small%2C%20it%20doesn't%20make%20sense%20to%20keep%20them%20in%20two%20separate%20sheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20could%20share%20some%20suggestions%20or%20thoughts%2C%20it%20would%20be%20great.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2379447%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMS%20Excel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPerformance%20Issues%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETables%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Is there any known performance issues when there are two or more tables in a same sheet?

 

Whenever I have more than 1 table in the same sheet then system takes a long time to insert rows or columns in those sheets.


I try to avoid having multiple tables in one sheet. But from a user experience perspective sometimes when each of the tables are too small, it doesn't make sense to keep them in two separate sheets.

 

If you could share some suggestions or thoughts, it would be great.

0 Replies