Hi,
I have a spreadsheet with a calculation using goal seek in a macro. This was built by another person, but it basically runs through 100 cells and calculates a value based on the result of the goal seek.
One thing I noticed is that when this was run it did not always solve for the correct answer, and after cell 75 it just recalculated the same number again and again. When I reran the goal seek on cell 75 it did solve to the correct value but the problem is I am worried something changed in the way this excel function works.
Has anyone else experienced this problem with 360? I ask because it is always being updated and the functionality is constantly in flux.
my version = Microsoft 365 MSO (Version 2405 build 16.0.17628.20006) 64-bit
Thanks,
I have a spreadsheet with a calculation using goal seek in a macro. This was built by another person, but it basically runs through 100 cells and calculates a value based on the result of the goal seek.
One thing I noticed is that when this was run it did not always solve for the correct answer, and after cell 75 it just recalculated the same number again and again. When I reran the goal seek on cell 75 it did solve to the correct value but the problem is I am worried something changed in the way this excel function works.
Has anyone else experienced this problem with 360? I ask because it is always being updated and the functionality is constantly in flux.
my version = Microsoft 365 MSO (Version 2405 build 16.0.17628.20006) 64-bit
Thanks,
