Deficiencies in Excel 2008

[roblake]

Running on MacPro, Tiger.

1. Chart a single 390-cell line. When I click on the chart line, the rightmost location says "Series 1 Point 448"

2. I have a value 0.000390509 in a cell which appears as 0.00039051 on the spreadsheet. "Find" can locate neither value.

I have reported both issues through the Help menu item.

 

[roblake]

Have two Excel 2008 spreadsheets open. One has rows of formulas, each like "=AVERAGE(B1:B1780)". Copy from that spreadsheet and Paste Special -> Formulas into the other.

Save the pasted-into spreadsheet and Close it. Re-Open it. The pasted-into cells all now contain VALUES and not FORMULAS! I've lost my formula work ...

 

[Bob Greenblatt]

Have two Excel 2008 spreadsheets open. One has rows of formulas, each like
"=AVERAGE(B1:B1780)". Copy from that spreadsheet and Paste Special -> Formulas
into the other.

Save the pasted-into spreadsheet and Close it. Re-Open it. The pasted-into
cells all now contain VALUES and not FORMULAS! I've lost my formula work ...

I can¹t make this happen. The formulas are intact, can be saved and reappear
when the document is reopened. Can you describe the exact steps you used?

 

[roblake]

Steps:
Fill A1 thru NZ1779 with values
Put =AVERAGE(A1:A1779) into cell A1781
 Click Save on the tool bar
Click the Red Dot to exit the worksheet
    Select Save from the dialog box that appears
==
Re-open the file, going thru the Delimited and Space separator dialogs
Check cell 1781. It now contains a VALUE, not a FORMULA

 

[Bob Greenblatt]

Steps:
Fill A1 thru NZ1779 with values
Put =AVERAGE(A1:A1779) into cell A1781
Click Save on the tool bar
Click the Red Dot to exit the worksheet
Select Save from the dialog box that appears
==
Re-open the file, going thru the Delimited and Space separator dialogs
Check cell 1781. It now contains a VALUE, not a FORMULA

If you are saving this as a text file, (as I assume by your instruction to
³going through the delimited...²), then you need to understand that text
files can ONLY contain values, not formulas. Save the file as an Excel
workbook and your formulas will stay in tact.

 

[roblake]

Thanks for pointing that out, Bob. The issue is two-fold now:
   - Apparently the "Save" logo on the ToolBar saves as text, but without the .txt filename and no choice presented to the user.
   - It saves over the text file that was originally Opened.

I guess I HAVE to use the "Save as .." from the drop-down File Menu.

 

[Bob Greenblatt]

Thanks for pointing that out, Bob. The issue is two-fold now:
- Apparently the "Save" logo on the ToolBar saves as text, but without the
.txt filename and no choice presented to the user.
- It saves over the text file that was originally Opened.

I guess I HAVE to use the "Save as .." from the drop-down File Menu.

The save icon on the tool bar will save the file to its original location
and format. You will need to do a Save-As to convert the file to an Excel
workbook. From then on save will save it in that format.