| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autosum not displaying until spreadsheet saved
I have a spreadsheet where a column is being autosummed (=sum(A1:A16)). The
figure does not appear in A17 until the worksheet is saved. Why? Something I discovered - the amount in A17 is being used in calculations in another column. That calculation is being used in a third. Is this the reason the autosum answer does not appear in A17 until CTRL-S is pressed or the worksheet is saved? If this is the case, can you point me to the specific rule or explanantion so I can share this with others? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spreadsheet not displaying | Excel Discussion (Misc queries) | |||
| The time the spreadsheet was saved | Excel Discussion (Misc queries) | |||
| Pie chart not displaying % in spreadsheet | Charts and Charting in Excel | |||
| Displaying URL images in a spreadsheet | Excel Discussion (Misc queries) | |||
| Can I unsave a spreadsheet once it has been saved | Excel Discussion (Misc queries) | |||
Threaded Mode
