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...