(Solved) Auto formating chart series after reload

%3CLINGO-SUB%20id%3D%22lingo-sub-3239903%22%20slang%3D%22en-US%22%3EAuto%20formating%20chart%20series%20after%20reload%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3239903%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20sheets%2C%20I%20have%20charts%20with%20serie%20formulas%20refering%20to%20names%20%2C%20themselves%20being%20dynamic%20(with%20if%20fuctions%20to%20trigger%20certain%20data%20inside%20the%20chart).%20The%20issue%20is%20that%20when%20I%20save%20and%20reopen%20the%20file%2C%20the%20series%20in%20the%20chart%20gets%20converted%20to%20static%20series%2C%20breaking%20the%20link%20to%20the%20name%20(%26nbsp%3B%20so%20for%20example%20%22%3Dsheet1!serie%22%20become%20a%20serie%20like%20this%20%22%3D%7B3464%5C3845%5C3087%5C2887%5C3507%5C3581%5C5225%5C5383%5C6044%5C6332%5C6635%5C7569%5C6839%5C6932%5C7747%5C7699%5C7803%5C7910%5C7882%5C7985%5C7906%5C7810%5C7807%5C8325%5C8678%5C8880%5C9367%5C9079%5C7882%5C7686%5C7983%5C8242%5C8329%5C8389%5C7823%5C7688%5C7635%5C7551%5C7925%5C8149%5C8793%5C9572%5C9740%5C10157%5C9724%5C9043%5C8033%5C8131%5C8290%5C7771%5C7845%5C7863%5C7952%5C9599%5C7642%5C6002%5C5719%5C5671%5C5858%5C5854%5C6343%5C6086%5C5228%5C5121%5C5505%5C4978%5C4862%5C5209%5C5145%5C5392%5C5304%5C5443%5C5313%5C4845%7D%22).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20an%20option%20to%20check%20or%20uncheck%20to%20avoid%20these%20auto-editings%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20reading%2C%3C%2FP%3E%3CP%3EClem%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3239903%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3241421%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20formating%20chart%20series%20after%20reload%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3241421%22%20slang%3D%22en-US%22%3ECheck%20under%20File%2FOptions%2FAdvanced%2FWhen%20calculating%20this%20workbook%20-%20update%20links%20to%20other%20docs%20and%20Save%20external%20link%20values.%20Check%20under%20Formulas%20that%20Auto%20is%20set.%20Review%20all%20the%20Options%20to%20ensure%20s%2Fs%20calculates%20dynamically.%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

In my sheets, I have charts with serie formulas refering to names , themselves being dynamic (with if fuctions to trigger certain data inside the chart). The issue is that when I save and reopen the file, the series in the chart gets converted to static series, breaking the link to the name (  so for example "=sheet1!serie" become a serie like this "={3464\3845\3087\2887\3507\3581\5225\5383\6044\6332\6635\7569\6839\6932\7747\7699\7803\7910\7882\7985\7906\7810\7807\8325\8678\8880\9367\9079\7882\7686\7983\8242\8329\8389\7823\7688\7635\7551\7925\8149\8793\9572\9740\10157\9724\9043\8033\8131\8290\7771\7845\7863\7952\9599\7642\6002\5719\5671\5858\5854\6343\6086\5228\5121\5505\4978\4862\5209\5145\5392\5304\5443\5313\4845}").

 

Is there an option to check or uncheck to avoid these auto-editings ?

 

Thanks for reading,

Clem

 

4 Replies
Check under File/Options/Advanced/When calculating this workbook - update links to other docs and Save external link values. Check under Formulas that Auto is set. Review all the Options to ensure s/s calculates dynamically.
Hi and thanks for your answer,

I've unchecked in the advanced options the "update links to other docs" and "save external link values", and It has solved the issue, thank you.
But I'm wondering, could these modifications cause other problems to appear ? On this file, I'll be making only dynamic charts, without macros (for compatibility issues with other platforms).
YW. These options are not related to macros. It will keep your doc dynamic. If your source data comes from another file, you need this turned on. If source is within the doc, you don't need it on. If someone moves the source doc you will get errors in your cells because it does not exist in that location. I don't think the compatibility will be affected (again, nothing w macros)

Okay, as every data is from the same doc, It'll be fine.

Thanks for the help,

 

Clem