ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Circular Reference (https://www.excelbanter.com/excel-discussion-misc-queries/182900-circular-reference.html)

revdeacon

Circular Reference
 
I am using Microsoft 2003. I have a 9MB workbook which has about 30
worksheets that link from outside sources as well as to one another.

When I email the spreadsheet as an attachment to others (normally zipped)
or post it on our intranet for others to access, they get a circular
reference error. I do not get the error. I have even opened the document that
I send to them and I do not get the error.

How can I fix this problem?

Thanks

joel

Circular Reference
 
Check the options on YOUR Tools - Option - Calulation Tab. The problem is
probably in YOUR excel and not the other people. You may have manual
calulations and not seeing ther error or the iteration setting is different
on your worksheet than the other people.

"revdeacon" wrote:

I am using Microsoft 2003. I have a 9MB workbook which has about 30
worksheets that link from outside sources as well as to one another.

When I email the spreadsheet as an attachment to others (normally zipped)
or post it on our intranet for others to access, they get a circular
reference error. I do not get the error. I have even opened the document that
I send to them and I do not get the error.

How can I fix this problem?

Thanks



All times are GMT +1. The time now is 08:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com