excel
excel copied to clipboard
justkawal
Formulas(linked with other sheet) Values Not Updating on Editing Sheet
I am trying to edit a sheet which is referenced in some other sheet and when i update/change its cell values and save it back its formulas values are not updated even are replaced by empty values but when i click on those (formula) cell it shows me correct formula and on entering it updated that cell values
I'm having a problem similar to this, I save data in flutter to a worksheet that is accessed by a PROCV from another worksheet, but the result is flawed. If I double click on the cell with the value created in flutter (without changing the value) and then click outside, PROCV starts working. It is also possible to make the entire column work by selecting and clicking on the "text to column" tool in the "data" tab. It is as if this tool did a cell split. The bad thing is that I have to keep doing this all the time to keep my other table fed with PROCV.
@JonyPower just a workaround for now if you are updating file Step1: Change your xlsx file to xlsm Step2: Under Developer Option (Choose Properties and select WorkBook.xml than Set ForceCalculation Property TRUE) and save file Step3: Export above xlsm again to xlsx file This will force recalculation of entire workbook file on opening
@MalikSamiAwan I couldn't find the ForceCalculation option. Do you know another way to do this or can you share an already configured xlsx file?
I already tried the ChatGPT option without success, the problem still occurred:
To choose properties and select the "WorkBook.xml" file to set the "ForceCalculation" property to TRUE, you can follow these steps:
Open Microsoft Excel on your computer.
Click on the "File" tab in the upper left corner of the Excel window.
From the menu on the left, select "Options." This will open the Excel Options dialog box.
In the Excel Options dialog box, select "Formulas" from the list on the left.
Under the "Calculation options" section, you will find the "Workbook Calculation" option.
Check the box next to "Enable iterative calculation" to enable it.
Optionally, you can adjust other calculation settings as needed.
Click "OK" to save the changes and close the Excel Options dialog box.
By enabling iterative calculation and adjusting the calculation settings in the Excel Options, you are essentially setting the "ForceCalculation" property to TRUE for the entire workbook, including the "WorkBook.xml" file.
@JonyPower here is the both xlsm and exported xlsx file
https://drive.google.com/drive/folders/16GcS6LL7FPtTgIlVd8DSsPvUmLfa0p49?usp=sharing
sample.xlsx