| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
No Sum= in HTM File
I create files using SAS, outputting to an HTM file, which opens up
easily in Excel. If I drag the cursor over a few cells I do not get the 'sum=....' note at the bottom, which happens with a regular XLS sheet. If I use the sum function, 'sum(b2:b4)', I'll get a result of 0, but if I enter '=b2+b3+b4' I get the correct number. Anyone know of what might be causing this and how to correct? Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel file lost | Excel Discussion (Misc queries) | |||
| Copy File Automatically on Opening It | Excel Discussion (Misc queries) | |||
| Pasword protected Excel file encrypted, how do I read this file? | Excel Discussion (Misc queries) | |||
| Links picking up values from an older version of linked file | Links and Linking in Excel | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Threaded Mode
