Temp file for storing addin formula

  • Thread starter Thread starter crapit
  • Start date Start date
C

crapit

which temp file contain excel formula? I use to clear temp file in my PC,
but that render certain formula in excel useless.

i.e weeknum(a1,1) become =-n/a# after clearing temp files
 
There are no temp files that contain those formulas.

If your formula
=weeknum(a1,1)
returned a different error (#NAME?), and you're using xl2003 or below, then that
would mean that you have turned off the analysis toolpak addin.

But since it returns the #n/a error, I'd look at what's in A1.

If this doesn't help, post your exact formula, the exact results and the
contents of the cells that are referred to in the formula.
 
Using Excel 2007. I didnt turn off any toolpak addin. It was working fine
until all of a sudden, it got error
 
Back
Top