Formula Problem 1

[wec43wec]

I have received a spreadsheet from another user that will not allow me to insert a formula on they existing spreadsheet.

When I enter "any" formula such as +a1+b1, the actual formala is displayed in the cell and not the results.

what could the problem be?

 

[SkipVought]

Hi,

Check Tools > Options > View Tab: Uncheck Formulas in Wodow Oprions.

Check Format > Cells > Number Tab: Unselect TEXT. Edit the cell and hit ENTER.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[wec43wec]

Skip - thanks !

The second option worked.

Question: What caused this issue?

 

[SkipVought]

Someone set that option.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[wec43wec]

Skip - it is my understanding that the data came from a CSV file - could that be the issue.

 

[SkipVought]

a .csv is ONLY a text file.

It was in the Excel workbook that opened the file.

WHERE did you enter this formula? Explain where the cell is with respect to the data directly from the .csv file.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[wec43wec]

Skip - not sure.

The formula was in a report on sheet1 and the raw data (CSV) was in sheet2.

I am not sure if sheet1 contain data directly from the CSV file. However I believe it was copied or pulled from Sheet2.

 

[SkipVought]

It is not likely that the .csv import affected anything on the other sheet.

Was that formula the only one? SOMEONE changed the option setting.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}