Thank you JE. I am totally with you, it is a somewhat frustrating situation.
Your "other" alternative sounds interesting but it will still lead to bosses
not being able to see directly what each cell is referencing to. Alas, no
wonder so many people crunch all kinds of spreadsheets in this place whereas
we only needed one Excel person.

"JE McGimpsey" wrote:

In article ,
Sally wrote:

Any suggestions to make this easier? Thank you for your comments.

How about telling your boss (and her bosses) to learn about rather basic
XL functions?

Present them with a spreadsheet (with very simple links) that calculates
the loss in productivity they're trying to impose, in

- hours,
- dollars, and
- the *SIGNIFICANTLY* reduced reliability associated with
having to routinely manually input links!

Ask them (politely) what the return on investment for ignorance is...

Alternatively, strict malicious compliance might allow one to put the
VLOOKUPs, HLOOKUPs, IF(ISNA())s, etc. in *other* cells, then create
links to *those* particular cells in the reports...