On the rogue PC try:-

Tools|addins and load the analysis toolpak.



Mike

"IanC" wrote:

In one workbook, I am using the function =EDATE(A1,1), etc to create a list
of months based upon the month entered in cell A1. This formula has worked
for ever on a variety of PCs. However, on one PC I am now getting the #VALUE
error returned, whilst it continues to work on my other PCs.

This implies it is a problem with that particular PC, but I cannot think
what this can be. Does anyone have any ideas as to where I could look.


IanC