R
Ron Lambert
I just got a new computer at work and it is loaded with XP
Professional which includes Excel 2002. I was running
Office 2000 on my old computer.
When I opened my old worksheets they often had little
triangles in the upper left hand corner of most cells.
When I clicked on them it said "inconsistent formula."
How do I get rid of the triangles? The formulas work.
Also, I can't seem to get the find/replace function to
work properly. I am refering to another worksheet and
2000 just automatically went out there to get the
replacements. In 2002 I have to go out to the worksheet
every time I replace something in a cell. Whenever I
opened the worksheets it said the links were not correct.
No matter how many times I update the links, I have to do
it again when I open the worksheet again.
Professional which includes Excel 2002. I was running
Office 2000 on my old computer.
When I opened my old worksheets they often had little
triangles in the upper left hand corner of most cells.
When I clicked on them it said "inconsistent formula."
How do I get rid of the triangles? The formulas work.
Also, I can't seem to get the find/replace function to
work properly. I am refering to another worksheet and
2000 just automatically went out there to get the
replacements. In 2002 I have to go out to the worksheet
every time I replace something in a cell. Whenever I
opened the worksheets it said the links were not correct.
No matter how many times I update the links, I have to do
it again when I open the worksheet again.