I RECENTLY RECEIVED AN E-MAIL WITH A ZIPPED EXCEL WORKBOOK ATTACHED, WHICH I
SAVED IN EXCEL. APPARENTLY ALL OF THE FORMULAS IN THIS WORKBOOK WERE
CONVERTED TO TEXT. NOW EVERY EXCEL WORKSHEET THAT I OPEN OR CREATE ACTS AS
THOUGH ALL FORMULAS ARE TEXT. I.E., I ENTER A FORMULA IN THE FIRST COLUMN
AND TRY TO DRAG IT TO SUBSEQUENT COLUMNS. THE SUBSEQUENT COLUMNS CONTAIN THE
FORMULA AS TEXT. DRAGGING THE FORMULA FROM THE INITIAL COLUMN ENTRY COPIES
THE VALUE OF THE RESULT OF THAT COLUMN TO ALL OTHER COLUMNS. IF THE SAME
FORMULA IS ENTERED IN ALL COLUMNS, ENTERING ADDITIONAL DATA IN A COLUMN DOES
NOT CHANGE THE TOTAL. IT IS NECESSARY TO REENTER THE SAME FORMULA AT THE
BOTTOM OF THE COLUMN AGAIN IN ORDER TO GET THE INSERTED ADDITIONAL DATA TO BE
REFLECTED IN THE SUM.

DO YOU HAVE CALCULATION SET TO MANUAL? And please don't type in ALL CAPS;
it's considered rude and is hard to read.

------

Vasant


"CHERYLZ" wrote in message
...
I RECENTLY RECEIVED AN E-MAIL WITH A ZIPPED EXCEL WORKBOOK ATTACHED, WHICH
I
SAVED IN EXCEL. APPARENTLY ALL OF THE FORMULAS IN THIS WORKBOOK WERE
CONVERTED TO TEXT. NOW EVERY EXCEL WORKSHEET THAT I OPEN OR CREATE ACTS AS
THOUGH ALL FORMULAS ARE TEXT. I.E., I ENTER A FORMULA IN THE FIRST COLUMN
AND TRY TO DRAG IT TO SUBSEQUENT COLUMNS. THE SUBSEQUENT COLUMNS CONTAIN
THE
FORMULA AS TEXT. DRAGGING THE FORMULA FROM THE INITIAL COLUMN ENTRY COPIES
THE VALUE OF THE RESULT OF THAT COLUMN TO ALL OTHER COLUMNS. IF THE SAME
FORMULA IS ENTERED IN ALL COLUMNS, ENTERING ADDITIONAL DATA IN A COLUMN
DOES
NOT CHANGE THE TOTAL. IT IS NECESSARY TO REENTER THE SAME FORMULA AT THE
BOTTOM OF THE COLUMN AGAIN IN ORDER TO GET THE INSERTED ADDITIONAL DATA TO
BE
REFLECTED IN THE SUM.