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

@Francs2345 

You may uncheck this setting in File->Options

image.png

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies