Workday function
I am using the WORKDAY function and occasionally the value it returns is
#NAME?. When it does this I can go to Add-Ins, uncheck the Analysis Tool Pak check box, then recheck the box and the WORKDAY funtion works again. Later, perhaps the next time I open the spreadsheet or perhaps in a few days it will quit working until I toggle the Tool Pak again. Why does it occasional quit working? The date in the WORKDAY function is a cell in a pivot table. Could that be the problem? Thanks for your help. David |
All times are GMT +1. The time now is 04:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com