Re-Calculation error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wrong amount or calculation error? 1
Reverse calculations 3
Calculating with 2 different formats 3
Very Long Calculation Times 1
Pictures 1
Calculate message 1
Do I need Excel or Access for my database needs? 3
Drop Down List and Validation for 3 different amounts 9

Back
Top