Re-Calculation error

5

5 Star

We have medium size spreadsheets which produce quotations and estimates for
our products. When finished the sheet, it gives a price which we send to
clients. Upon opening the same sheet again, it (sometimes) gives a different
price. Not a huge amount but still different. Auto Calc is on.

Could anybody help with this problem.
 
N

Niek Otten

We need more info to be able to help you!

Any User Defined Functions in the sheet? Any NOW() or TODAY() function
calls? No links to external sources?
What formulas? What input values, what result, which one is right and why?

No other sheets active when this one is used, in both circumstances?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
5

5 Star

The sheet has got Now() and Today() functions. They also have links to
another spreadsheet for pricing of materials.

I don't understand whatis meant by...
"No other sheets active when this one is used, in both circumstances"

The only thing that would be easier is to send a sheet for someone to look at?

Thanks
5 Star
 
Top