| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel change SUM references if you cut & paste the first cell in SUM...
Hi,
A problem came from a user today. Set up: IN A1: " =SUM(A2:A6) " and in A8: " =SUM(A9:A13) " and fill in some figures in A9:A13. Cut A10 and paste it to A4. everything is ok. If I cut A9 you get "Circular Reference error, because the formula in A8 has changed to: " =SUM(A4:A13) " and the old SUM it still there in A8. Why? Should it be that way, and what is the purpose? Any workarounds? /Kind regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| Paste without including cell borders | Excel Worksheet Functions | |||
| Cell References in Functiona | Excel Worksheet Functions | |||
| Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) | |||
Threaded Mode
