Bru'n Water and OfficeSuite

[SEndorf]

I no longer have an Office 360 subscription with Excel. I now have Office Suite which has basically the same programs (word, sheets, etc.) but now the cells in Bru'n Water won't update when changing data.
Any advice on how to make this work is appreciated!

 

[mabrungard]

It sounds like you need to set that Suite to auto recalculate. What you're describing sounds like its set to Manual recalculation.

 

[SEndorf]

It sounds like you need to set that Suite to auto recalculate. What you're describing sounds like its set to Manuamartin, but Il recalculation.

Thanks

 

[SEndorf]

Thanks martin, but I do not see any options to do this.

 

[day_trippr]

The "Sheets" in Office Suite looks like repackaged Google Sheets.

If that's the case (or just give this a try) go into File - Settings - Calculation, and enable Iterative Calculation. That defaults to 50 but I upped it to 200 just on general principle and at least my paid version 5.5 appears to work correctly using "Sheets"...

Cheers!

 

[SEndorf]

Thanks for the replies.
I dug into the "sheets" settings and find only the option to "auto complete for cell values". No other options. Looks like I'll need the google version for this.