Temp file for storing addin formula

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
 
D

Dave Peterson

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.
 
C

crapit

Using Excel 2007. I didnt turn off any toolpak addin. It was working fine
until all of a sudden, it got error
 
Top