Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default Circular Reference Warning

When I open my exel file .. this pop-up open ..

circular reference warning
one or more formulas contain a circular reference and may not calculate
correctly. circular references are any references within a formula that
depend upon the results of that same formula. for example, a cell that refers
to its own value or a cell that refers to another cell which depends on the
original cell's value both contain circular references.
for more information about understanding, finding, and removing circular
references, click ok. if you wnat to create a circular reference, click
cencel to continue

That file was my friend's financial file. { very very important for
him.Because of no backup! }He asked me to repair his file but I don't have
enough experience for that error. Please help me if you can. Please ..

This is my file.
http://www.mediafire.com/?nc0xjg0f02i
0.98MB

If you can .. download it and repair and upload me again.. Thanks..
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 102
Default Circular Reference Warning

I presume you're using Microsoft Office 2007,
You've got some bad programming on the formulas here.
Basically it's like bad algebra. You've got X+Y=Z
And Z=X It going in circles.

If you save it as a Excel 2003 file, I'll try to help you.

"NeiLi" wrote:

When I open my exel file .. this pop-up open ..

circular reference warning
one or more formulas contain a circular reference and may not calculate
correctly. circular references are any references within a formula that
depend upon the results of that same formula. for example, a cell that refers
to its own value or a cell that refers to another cell which depends on the
original cell's value both contain circular references.
for more information about understanding, finding, and removing circular
references, click ok. if you wnat to create a circular reference, click
cencel to continue

That file was my friend's financial file. { very very important for
him.Because of no backup! }He asked me to repair his file but I don't have
enough experience for that error. Please help me if you can. Please ..

This is my file.
http://www.mediafire.com/?nc0xjg0f02i
0.98MB

If you can .. download it and repair and upload me again.. Thanks..

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Circular Reference Warning NeiLi New Users to Excel 1 July 8th 09 10:21 PM
Circular Reference Warning NeiLi New Users to Excel 3 July 8th 09 09:23 AM
Circular Reference Warning NeiLi New Users to Excel 0 July 7th 09 09:23 PM
Circular Reference build Excel Worksheet Functions 1 October 19th 07 01:08 PM
Circular warning not showing up Arran Excel Discussion (Misc queries) 1 June 20th 05 08:55 PM


All times are GMT +1. The time now is 03:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"