Tech Support Forum banner
Status
Not open for further replies.
1 - 5 of 5 Posts

·
Registered
Joined
·
3 Posts
Discussion Starter · #1 ·
Hi

I hava an application where, for no reason the data will change around row 140-150, or the formula will modify itself.

Ant help will be appreciated.

I am usin Win XP PRO and Office 2003 all files are up to date.


Thank you for your answer

REMPLUS
 

·
Registered
Joined
·
1,515 Posts
You're going to need to provide more info. Does your workbook contain macros? What is the formula that "modifies itself"? Maybe some examples of the data that is changing? Are the changes happening while the workbook is open, or just that it is different from the last time it was opened?
 

·
Registered
Joined
·
3 Posts
Discussion Starter · #3 ·
Here is the situation.

One exemple the worst one

Formulas from row 6 to row 302
=CHOISIR(param!L4C2;'Relevé des fonctions'!LC(21);'Relevé des fonctions'!LC(20);'Relevé des fonctions'!LC(108))

At row 144 and 145 the formula change :
=CHOISIR(param!L4C2;'Relevé des fonctions'!L(1)C(21);'Relevé des fonctions'!L(1)C(20);'Relevé des fonctions'!L(1)C(108))

From row 146 to 248, the formula change :
=CHOISIR(param!L4C2;'Relevé des fonctions'!L(2)C(21);'Relevé des fonctions'!L(2)C(20);'Relevé des fonctions'!L(2)C(108))

At row 249 : formula change similar to row 144 and 145.

From row 250 to 289 formula changed similar to row 146 to 248.

Row 281 formula change to :
=CHOISIR(param!L4C2;'Relevé des fonctions'!L(-137)C(21);'Relevé des fonctions'!L(-137)C(20);'Relevé des fonctions'!L(-137)C(108))

From row 282 to 287 formula is similar to row 144 and 145.

At row 288 the formula is :

=CHOISIR(param!L4C2;'Relevé des fonctions'!L(-141)C(21);'Relevé des fonctions'!L(-141)C(20);'Relevé des fonctions'!L(-141)C(108))

From row 289 to 302(end) the formula is ok

During our nomal work with this woorbook, we don’t have any reason to modify that column or the row.

Another type of error: The data that is changing are regular number from 1 to 9. those changes are found out after opening the file.

Hope this will help you
 

·
Folding Along
Joined
·
2,304 Posts
It looks as if some of the Row/Column addresses were relative rather than absolute when the formula was originally copied into those rows. If you correct the formulae, do they revert to incorrect after a save and re-open?
 

·
Registered
Joined
·
3 Posts
Discussion Starter · #5 ·
Re: EXCEL 2003 data and or formula are changing by themself. SOLVED FOR FORMULA

:pray:Thank you GISTEK, this was the problem for the formula (I hope). We are not expert at L1C1 reference that does express Relative/Absolute in a different way.

REMPLUS
 
1 - 5 of 5 Posts
Status
Not open for further replies.
Top