Excel formulas

[julianf]

Hi,

We run Office XP with Office XP-SP3 on our systems. A few users have complained that the excel formulas seem to be malfunctioning on some of their docs.

Spreadsheets which worked fine in the past, now have problems when additional data is added. The formula does not seem to pick up the new data.

The only work-around at times is to copy the entire spreadsheet into a new one.

Does anyone have any idea what the problem may be? Perhaps there is a patch for this?

Thanks,

Julian

 

[KenWright]

Couldn't just be that they haven't enabled the 'extend list formats and formulas' option in Tools / options / Edit Tab, could it?

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[julianf]

Hi,

Its enabled by default on my system which is also running Office XP....but I will double check the settings on their systems.

If that setting is disabled, what effect does it have?

Thanks,

Julian

 

[SkipVought]

Julian,

It seems that you might have macros that extend certain named data areas, or dynamic formulas in Insert/Name/Define.

Have them check Tools/Macro/Security to make sure that either the High option is NOT selected.

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[julianf]

Thanks...HIGH is selected on my system - will it be fine to change this to "MEDIUM"?

 

[SkipVought]

Yes, with MEDIUM, the user gets to decide whether or not to open with macros.

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[KenWright]

You might also want to consider using Named dynamic formulas to self adjust ranges with the addition of new data to a list. I never trust Excel to do it for me, and always go for a belt and braces approach.

Regards
Ken...........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------