I have a large spreadsheet that has multiple vlookups, both internal &
external ones.

All of the internal lookups ( to other sheets within the workbook) have
disappered - just like breaking the links to external SS.

Is there anyway of monitoring internal lookups?

On Feb 6, 10:39 pm, Sean wrote:
I have a large spreadsheet that has multiple vlookups, both internal &
external ones.

All of the internal lookups ( to other sheets within the workbook) have
disappered - just like breaking the links to external SS.

Is there anyway of monitoring internal lookups?


Try Tools Formula Auditing Evaluate Formula

The only way they would have broken through is if someone deleted the
sheet and/or any defined names that are used, and baring that the
values your searching for is no longer in the workbook on that
worksheet

Hi Sean:

Are the formulas still there?

Post an example of the formula.

Also try the auditing tool and trace precendents.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Sean" wrote:

I have a large spreadsheet that has multiple vlookups, both internal &
external ones.

All of the internal lookups ( to other sheets within the workbook) have
disappered - just like breaking the links to external SS.

Is there anyway of monitoring internal lookups?