Excel 2003 error

[EvelynTeo]

i was using excel 2003 for normal billing and accounting purposes. But
recently dunno wat key that i pressed,all my excel worksheet changes its
formula.
For example: i use link between cell,worksheet and workbook
but now,whenever i change the contents in the main cell,the linked cells
wouldn't change accordingly.

somebody please tell me the problems and how to fix it. i need use tis excel
everyday and need to fix it asap. thank you.

 

[Jan Karel Pieterse]

Hi EvelynTeo,

i use link between cell,worksheet and workbook
but now,whenever i change the contents in the main cell,the linked cells
wouldn't change accordingly.

Tools, Options, Calculation tab, set calculation back to automatic.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[EvelynTeo via OfficeKB.com]

tq so much..fix the problems ored.

i was using excel 2003 for normal billing and accounting purposes. But
recently dunno wat key that i pressed,all my excel worksheet changes its
formula.
For example: i use link between cell,worksheet and workbook
but now,whenever i change the contents in the main cell,the linked cells
wouldn't change accordingly.

somebody please tell me the problems and how to fix it. i need use tis excel
everyday and need to fix it asap. thank you.