Changes to Excel after e-mailing

[Guest]

Using Office 2003 - Excel Spreadsheet is e-mailed to 3
people, results of Formulas are different when each person
opens Excel Spreadsheet. All are using Office 2003.
Any Thoughts on this.

Thanx
truckersdad

 

[Guest]

Some possible answers may be:

1. Automatic Calculations turned on/off
2. External References updating or not
3. Macros Enabled/Disabled
4. Add-Ins installed or not
5. Use of Random funcion

If you provide the formulas, how the formulas are getting data, and the
different results, we may be able to give you a more specific answer.

HTH,
Elkar

 

[Guest]

I found how to fix this problem when I was checking the Macros,
I found the security was set to high (default), there was no prompt
asking if Macros should be run. When I set to low, I was prompted
whether I wanted to run macros. After I answered yes, the correct
results came in on the spreadsheet.

Thank you Elkar for pointing me in the right direction.