cells not updating from other sheets
Situation:
Numbers 3.2.2
OSX 10.9.4
Mac Book Pro, 8GB RAM, 2.5 GHz Intel i5
A spreadsheet file is stored in a dropbox folder and opened locally on a MAC for input.
Multiple people have access to the Dropbox folder but only one person has the sheet open locally.
We use 1 numbers spreadsheet file consisting of 9 sheets.
8 of the sheets only have one table on them (i.e. 1 table per sheet.)
Each table has one or more header cells using a simple Sum(<column>) calculation.
The 9th sheet is a summary sheet which pulls info from the summed header cells on the other 8 sheets.
The summary sheet performs various calculations automatically.
Its a simple price list spreadsheet. Input a qty for various items on the 8 sheets, the header cell sums all the inputs, the summary sheet shows various info for taxes, shipping, etc.
Everything works fine as long as you are going one direction (i.e. entering info for the first time). The trouble comes when you have to change the inputs on the other sheets.
Sometimes the summary sheet won't update with the new amounts from the other sheets. I can force it to update by going to the summary sheet cell, double click like I'm going to change the formula, hit enter...and boom...recalculation is performed.
I've noticed this has been a problem since Numbers 3 came out. Not sure if it was after the 1st or second update.
Has anyone else come up with a work-around for this?
Is there a way to force a sheet to refresh (i.e. a button to put on the sheet for the user to press that executes a "macro" forcing a recalculation)?
This has been very frustrating and potentially costly to our business.
Thanks.