Excel deletes formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1526789%22%20slang%3D%22en-US%22%3EExcel%20deletes%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1526789%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20afternoon.%3CBR%20%2F%3EI'm%20having%20a%20little%20problem%20with%20my%20Excel%20spreadsheet.%3CBR%20%2F%3EI%20have%20created%20an%20external%20connection%20to%20an%20XML%20file%20and%20am%20importing%20certain%20source%20nodes%20to%20my%20spreadsheet.%20So%20far%20so%20good...%3CBR%20%2F%3EWhen%20the%20source%20data%20gets%20bigger%20excel%20gives%20the%20following%20message%3A%20%22This%20table%20has%20rows%20inserted%20into%20your%20workbook.%20Data%20in%20cells%20below%20the%20table%20may%20be%20moved%20down.%3CBR%20%2F%3Eand%20all%20formula%20references%20are%20broken.%3CBR%20%2F%3EIs%20there%20anything%20you%20can%20do%20to%20stop%20this%20from%20happening%20again%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1526789%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Good afternoon.
I'm having a little problem with my Excel spreadsheet.
I have created an external connection to an XML file and am importing certain source nodes to my spreadsheet. So far so good...
When the source data gets bigger excel gives the following message: "This table has rows inserted into your workbook. Data in cells below the table may be moved down.
and all formula references are broken.
Is there anything you can do to stop this from happening again?

0 Replies