View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rexie3 rexie3 is offline
external usenet poster
 
Posts: 14
Default AddIn Analysis Pak not working anymore

I have an excel sheet that calculates a customer's usage forecast. I use
formulas like MROUND and IF statements. For some reason I'm getting a #Name?
error now in the MROUND formula. My first formula is =MROUND(F5,D3).

My Tools, AddIns has both Analysis Paks checked off and this spreadsheet has
worked before. I don't know what has happened to make this function not work
anymore.

Is there a test I can do to see if I have a file missing all of a sudden
from my desktop? Or how can I reload my addins?

Thank you very much in advance