Excel guru.

Got an Excel file that gives me circular reference error.

Excel guru.

Got an Excel file that gives me circular reference error.

That usually means you have a cell that points to a cell that points back to the original cell. Or a cell that points to itself.
http://office.microsoft.com/en-us/excel/HP100662431033.aspx

That usually means you have a cell that points to a cell that points back to the original cell. Or a cell that points to itself.
http://office.microsoft.com/en-us/excel/HP100662431033.aspx

I figured it out GW. It was my sisters schedule for work. The company had written this file for her.

Thanks

That usually means you have a cell that points to a cell that points back to the original cell. Or a cell that points to itself.
http://office.microsoft.com/en-us/excel/HP100662431033.aspx
:yeahthat: Circular's are pretty easy to figger out.

:yeahthat: Circular's are pretty easy to figger out.

When the error window popped up you have an option to click "ok" which brings up the help. That's how I figured it out. Come to find out it had a formula ($A$1) for a file that just did scheduling.

I'm just not a winders person. Hence my name. :lol:

When the error window popped up you have an option to click "ok" which brings up the help. That's how I figured it out. Come to find out it had a formula ($A$1) for a file that just did scheduling.

I'm just not a winders person. Hence my name. :lol:


unix-pirate? aah haa

unix-pirate? aah haa

At least Unix is spelled the way it is..... :whistle:

At least Unix is spelled the way it is..... :whistle:

Thought you were asleep and getting ready for your trip.. :smack:



:lol:

unix-pirate? aah haa

:confused:

Thought you were asleep and getting ready for your trip.. :smack:



:lol:

I sleep-write in these forums now..... :biggrin:

Just leaving now. Happy New Year!