Re-Calculation error

[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.

[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 Star" <5 Star@discussions.microsoft.com> wrote in message
news:FF8446FE-70CB-456A-8ABE-AB9AC5542C58@microsoft.com...
> 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.

[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


"5 Star" wrote:

> 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.