Charts Won't Update Under "ForceFullCalculation"

%3CLINGO-SUB%20id%3D%22lingo-sub-881735%22%20slang%3D%22en-US%22%3ECharts%20Won't%20Update%20Under%20%22ForceFullCalculation%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-881735%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20face%3D%22Calibri%22%20color%3D%22%23000000%22%3EI%20had%20a%20~16MB%20Excel%20file%20that%20was%20loading%20slowly%20and%20performing%20poorly%20(~1%20minute%20to%20recover%20from%20a%20simple%20operation%20of%20unhiding%20rows%20that%20were%20%22Grouped%22).%20I%20found%20an%20article%20that%20suggested%20turning%20%22ForceFullCalculation%22%20to%20%22True%22%20in%20Visual%20Basic%20Workbook%20properties.%20I%20tried%20it%2C%20and%20performance%20dramatically%20improved%3B%20however%2C%20now%20charts%20won't%20update%20to%20reflect%20changes%20in%20tables%20feeding%20the%20charts.%20I%20spoke%20with%20MS%20Support%3A%20their%20Tier%202%20noted%20that%2C%20%22Force%20Full%20Calculation%20actually%20turns%20off%20features%20(like%20updates)%20to%20get%20processing%20power%22%2C%20and%20weren't%20able%20to%20provide%20any%20further%20assistance...but%20they%20did%26nbsp%3Bpoint%20me%20to%20this%20community.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20face%3D%22Calibri%22%20color%3D%22%23000000%22%3ECan%20anyone%20here%20help%3F%20I%20need%20the%20responsiveness%20that%20%22FFC%22%20brought%2C%20but%20I%20need%20my%20charts%20to%20update%20when%20changes%20are%20made%20to%20the%20underlying%20data.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-881735%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Regular Visitor

I had a ~16MB Excel file that was loading slowly and performing poorly (~1 minute to recover from a simple operation of unhiding rows that were "Grouped"). I found an article that suggested turning "ForceFullCalculation" to "True" in Visual Basic Workbook properties. I tried it, and performance dramatically improved; however, now charts won't update to reflect changes in tables feeding the charts. I spoke with MS Support: their Tier 2 noted that, "Force Full Calculation actually turns off features (like updates) to get processing power", and weren't able to provide any further assistance...but they did point me to this community.

 

Can anyone here help? I need the responsiveness that "FFC" brought, but I need my charts to update when changes are made to the underlying data.

0 Replies