ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cannot make formulas work across tabs (https://www.excelbanter.com/excel-discussion-misc-queries/140120-cannot-make-formulas-work-across-tabs.html)

Mark Hirsch

Cannot make formulas work across tabs
 
Something happened to my machine and I cannot make even the simplest formula
work across TABs in the same document. It gives me a bizarre cirular
reference error in a few cels away fro where the target data came from.

I believe some core file is corupted.

I have reinstalled Office 2007 3 to no avail.

Anyone have any ideas?

Mark

Dave Peterson

Cannot make formulas work across tabs
 
Are you sure you just haven't found the real circular reference?

You may want to try Stephen Bullen's utility:
http://www.oaltd.co.uk/Excel/Default.htm
Look for FindCirc.zip

Mark Hirsch wrote:

Something happened to my machine and I cannot make even the simplest formula
work across TABs in the same document. It gives me a bizarre cirular
reference error in a few cels away fro where the target data came from.

I believe some core file is corupted.

I have reinstalled Office 2007 3 to no avail.

Anyone have any ideas?

Mark


--

Dave Peterson


All times are GMT +1. The time now is 12:36 PM.

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