Calculation & Columns run

  • Thread starter Thread starter GCK
  • Start date Start date
G

GCK

Hi,

I've some questions as following :

My PC with Windows 98 SE OS and using Microsoft Office 97
Standard Edition and with Ms Excel 97.

I've the *.xls files and have quite of number sheet are
created. And every sheets are linked to each others.

I've encountered the following problems :

1) i've done my worksheet, and saved and closed. After
that try to re-open the files has been saved previously,
some of the amount of calculation are being changed. After
that, i closed again the file, and try to open on the same
file, the amount of calculation changed again. What is the
problem on it ?

2) After i've adjusted the columns alignment, and saved
the files. After re-open again, the columns alignment run
again.

Please advise as above.

Thanks !

GCK
 
1. value of =RAND() changes at every open. Do you have =RAND() in your
worksheet?
2. if you save in another format like .csv columns won't keep their
attributes. Are you sure the file type (from the save screen) is Excel?
 
There are a few worksheet functions that would give you that message when you're
closing xl:

This was posted by Myrna Larson a while ago:

Article Q248179 gives this list. TODAY() is omitted, but I think they just
forgot it here:


AREAS()
INDEX()
OFFSET()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()


Some posters say that upgrading to SR2 gets rid of the column changing problem.
But others have said that it had no effect.

If you're not running xl97SR2, you may want to try it.
 
1)

-----Original Message-----
1. value of =RAND() changes at every open. Do you have =RAND() in your
worksheet?
2. if you save in another format like .csv columns won't keep their
attributes. Are you sure the file type (from the save screen) is Excel?






.
Click to expand...
 
1. What is =RAND() ?
2. All the while my excel document will save in *.xls
only. Never save it as *.csv before.

Pls Advise
 
Back
Top