Home

How to add rows to a table without having the formulas auto populate?

%3CLINGO-SUB%20id%3D%22lingo-sub-892311%22%20slang%3D%22en-US%22%3EHow%20to%20add%20rows%20to%20a%20table%20without%20having%20the%20formulas%20auto%20populate%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-892311%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20add%20rows%20to%20a%20table%2C%20the%20formulas%20seem%20to%20be%20embedded%20in%20the%20table%20and%20they%20are%20auto%20populating.%20My%20data%20set%20is%20large%20so%20it's%20causing%20it%20to%20crash.%20What's%20weird%20is%20that%20not%20all%20formulas%20are%20auto%20populating%2C%20only%20certain%20columns.%20I%20don't%20want%20any%20of%20the%20formulas%20to%20populate.%20I%20want%20to%20just%20copy%20and%20paste%20them%20after%20I%20add%20my%20data%20to%20the%20table.%20Hope%20this%20makes%20sense.%20I%20truly%20appreciate%20any%20help%20that%20is%20out%20there%20because%20it%20would%20save%20me%20a%20ton%20of%20time.%20Thanks%20in%20advanced.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-892311%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-892378%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20rows%20to%20a%20table%20without%20having%20the%20formulas%20auto%20populate%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-892378%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F419753%22%20target%3D%22_blank%22%3E%40Francs2345%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20uncheck%20this%20setting%20in%20File-%26gt%3BOptions%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20682px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F135381i79565F6FFFA66358%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Francs2345
Occasional Visitor

When I add rows to a table, the formulas seem to be embedded in the table and they are auto populating. My data set is large so it's causing it to crash. What's weird is that not all formulas are auto populating, only certain columns. I don't want any of the formulas to populate. I want to just copy and paste them after I add my data to the table. Hope this makes sense. I truly appreciate any help that is out there because it would save me a ton of time. Thanks in advanced.

1 Reply
Highlighted

@Francs2345 

You may uncheck this setting in File->Options

image.png

Related Conversations
Teams no longer auto launches
trandall in Microsoft Teams on
4 Replies
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
SUM formula help needed with multiple criteria
Eileen Skidgel in Excel on
5 Replies