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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies