Hi,
I have encountered a weird problem
I have a cell which uses the formula
where 'holidays' is a dynamic range name. The formula used to evaluate correctly.
I sent the workbook to someone else who encountered a problem and found that this cell evaluated to #Name. We eventually identified the problem in that he did not have the Analysis Tool Pak VBA add in installed. Once he'd installed it the problem disappeared - apparently.
In identifying the problem, at some stage I unticked my Analysis Tool Pak add in to prove that I got the same problem as he did - which I did. Once we'd proved that I again ticked the Add in box.
However I now find that when I load the workbook, although the cell evaluates correctly on initial opening, as soon as I copy the formula from the equivalent formula in the line above, it evaluates to #Name. However if I F2 to open the edit and then immediately enter the value back again, it evaluates correctly.
I've done all the obvious things like re-booting but nothing seems to overcome this problem with the copying part of the process.
Can anyone offer any clues...
Usual TIA
Bookmarks