| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EDate Unrecognized When Spreadsheet Opened Again
I have several spreadsheets and I made changes to a LOT of formulas using the
EDate function. I have the Analysis Tool Pack add-in checked in Excel. It all worked fine yesterday. Today, if I open the ss, I get the #NAME error. I have to go to Add Ins, uncheck the Analysis Tool Pack, hit okay, then go back and re-activate it in order to make my formula calculate. I save and close the spreadsheet, and I open it again with the same error. Is this a bug or does anyone know what is going on? Please help. I have used this function in about 200 ss's in about 50 fields per ss! These ss's are shared, and I've asked everyone who uses them to activate the add-in. Can you help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selling & Protecting An Excel Spreadsheet | Excel Discussion (Misc queries) | |||
| Shared spreadsheet changes color when opened ny another user. Why | Excel Worksheet Functions | |||
| Generating Simple Reports From A Master Spreadsheet | Excel Worksheet Functions | |||
| Spreadsheet merging problems | Excel Worksheet Functions | |||
| Link Soucre changes when Spreadsheet opened from with within Outlook | Links and Linking in Excel | |||
Threaded Mode
