Simple formula appers to work fine, then bongs!

[SG1]

This formula worked fine, and then one day when I changed one of the values (H3), I get the #name? error, and undo won't correct it; see for yourself; any help would be appreciated.

http://www.chebucto.ns.ca/~aj369/FreqTime.xls

(Used for calculating Frequency at different times)

 

[SG1]

Yup, I've just finished installing it and now it works perfectly (as it used to)

The problem came after I restored my system drive from a backup that I made _before_ I installed the tool-pak;
_________________


/ Wallace
This message was edited by SG1 on 2002-09-02 16:15

 

[Ian Mac]

It does sound like the Analyst Tool-Pack not installed as Paddy says.
But I just opened the file in xlXP and I get the #NAME! as well, and I have the Add-In installed.
Remove the Add-In, then put it back in and re-calc, problem solved????

I have had this a few times with XP of late.
In particular when I use RANDBETWEEN() in a new file, I don't know which version of xl your running, but this be an issue.

 

[SG1]

It does sound like the Analyst Tool-Pack not installed as Paddy says.
But I just opened the file in xlXP and I get the #NAME! as well, and I have the Add-In installed.
Remove the Add-In, then put it back in and re-calc, problem solved????

I have had this a few times with XP of late.
In particular when I use RANDBETWEEN() in a new file, I don't know which version of xl your running, but this be an issue.
_________________
Share the wealth!!
Ian Mac

Interesting, but it turns out my problem came about when using a backup of my system drive (with Excel on it) that was made before I installed the tool-pak; see my last post on the first page.

Yet another reason why I'm still using Win98 SR-1

_____________

/ Wallace
This message was edited by SG1 on 2002-09-02 16:24

 

[Ian Mac]

On 2002-09-02 16:20, SG1 wrote:

It does sound like the Analyst Tool-Pack not installed as Paddy says.
But I just opened the file in xlXP and I get the #NAME! as well, and I have the Add-In installed.
Remove the Add-In, then put it back in and re-calc, problem solved????

I have had this a few times with XP of late.
In particular when I use RANDBETWEEN() in a new file, I don't know which version of xl your running, but this be an issue.
_________________
Share the wealth!!
Ian Mac

Interesting, but it turns out my problem came about when using a backup of my system drive (with Excel on it) that was made before I installed the tool-pak; see my last post on the first page.

Yet another reason why I'm still using Win98 SR-1

_____________

/ Wallace
This message was edited by SG1 on 2002-09-02 16:24

But isn't Win98 SE the most stable???
That the operating system I'm using at home.

It's office XP I'm have problems with,
I still have 97 and 2000 installed though (which if you read the terms is a big no no??).

 

[SG1]

Well, that's what I hear from most people, but my machine hasn't crashed unexpectedly since two months after I got it.

The differences between SR-1 and SE are really behind the scenes (hence the different drivers for 9x and SE), and my stuff works with the 9x drivers, so why gamble with probably haste-written SE drivers?
_________________


/ Wallace
This message was edited by SG1 on 2002-09-02 16:50

 

[Todd Bardoni]

I'm seeing the same thind as SG1. This is very strange because the formula looks fine. I'm using ExcelXP and Win98...very strange.

 

[PaddyD]

obvious question, but do you have the analysis tool pack installed?
Paddy