View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default circular reference warnings

I'm not sure about the 'blinking' part, but if you click Tools Options
Calculation Iteration to solve the circular reference problem. Notice:
the next time you open the workbooks this will be disabled (turned off). As
far as I know, this feature is always disabled when Excel starts up.
Unless you really want that Circular Reference, and sometimes you actually
do, it may be better to resolve that €˜problem.

Regards,
Ryan--


--
RyGuy


"MATTMCG" wrote:

After I received a circular reference warning my worksheet started blinking.
I couldn't get out of the worksheet to try any other action such as search
for the circular refernce to delete it but all I get is a blinking worksheet
- All I could do was get in to "Help" and this blog request - Can anyone help
me to deactivate the blinking