In need of a

[unixpirate]

Excel guru.

Got an Excel file that gives me circular reference error.

[GWguy]

Originally Posted by unixpirate

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/ex...662431033.aspx

[unixpirate]

Originally Posted by GWguy

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/ex...662431033.aspx

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

Thanks

[Baja28]

Originally Posted by GWguy

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/ex...662431033.aspx

Circular's are pretty easy to figger out.

[unixpirate]

Originally Posted by Baja28

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.

[ginwoman]

Originally Posted by unixpirate

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.

unix-pirate? aah haa

[GWguy]

Originally Posted by ginwoman

unix-pirate? aah haa

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

[unixpirate]

Originally Posted by GWguy

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

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

[unixpirate]

Originally Posted by ginwoman

unix-pirate? aah haa

[GWguy]

Originally Posted by unixpirate

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

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

Just leaving now. Happy New Year!