I've been using Excel daily in my job for ten years and am highly
experienced, but I seem to have made some setting change recently that I
can't figure out. If I try to enter a formula in Sheet1 (say, in cell A1)
and link it to a cell in Sheet2, the formula places itself in cell A1 on
Sheet2, not Sheet1. I'm sure this must be a setting I've made. Does anyone
have any ideas? Thanks.

--
Dave

Sorry, I don't know the answer to this. But you might try posting
directly to the Excel group where there's a better chance of getting
an answer, if you don't get one here.

Good luck...

Dian D. Chapman
Technical Consultant, Microsoft MVP
MOS Certified, Editor/TechTrax

Free MS Tutorials: http://www.mousetrax.com/techtrax
Free Word eBook: http://www.mousetrax.com/books.html
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html


On Thu, 15 Feb 2007 15:42:05 -0800, Dave
<Dave@discussions.microsoft.com> wrote:

>I've been using Excel daily in my job for ten years and am highly
>experienced, but I seem to have made some setting change recently that I
>can't figure out. If I try to enter a formula in Sheet1 (say, in cell A1)
>and link it to a cell in Sheet2, the formula places itself in cell A1 on
>Sheet2, not Sheet1. I'm sure this must be a setting I've made. Does anyone
>have any ideas? Thanks.