Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute changes w/copy
Really irritating. I have a file that I got with a book
from Microsoft press. After I enter a formula, absolute part of it with F4(it is a running total, front part is absolute ie =SUM($O$1081:O1090)), then I try and copy the formula up. The absolute goes away and I end up with something like =SUM($O1068:O$1081. This is really frustrating and only seems to be happening with the files from the disk I got from Microsoft press with the book, "Excel Data Analysis and Business Modeling," ISBN 0-7356- 1901-8. Just got the book and am not too far into it yet, but I have run across other problems ie errors in the book. Anyone else using this book and having similar problems. Trying to avoid e mail junk, so I am not putting in my e mail address. Thanks, David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute changes w/copy
You are right but I don't believe it has anything to do with the book. Excel
seems to get confused when you copy the formula from below the fixed cell ($O$1081) to above the fixed cell. It is not behavior that I would expect. OTOH, I've never seen a running total being maintained above *and* below the fixed cell, so I'm not quite sure what you are attempting to do. -- Vasant "David" wrote in message ... Really irritating. I have a file that I got with a book from Microsoft press. After I enter a formula, absolute part of it with F4(it is a running total, front part is absolute ie =SUM($O$1081:O1090)), then I try and copy the formula up. The absolute goes away and I end up with something like =SUM($O1068:O$1081. This is really frustrating and only seems to be happening with the files from the disk I got from Microsoft press with the book, "Excel Data Analysis and Business Modeling," ISBN 0-7356- 1901-8. Just got the book and am not too far into it yet, but I have run across other problems ie errors in the book. Anyone else using this book and having similar problems. Trying to avoid e mail junk, so I am not putting in my e mail address. Thanks, David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy absolute formulas | Excel Discussion (Misc queries) | |||
Copy and paste absolute reference | Excel Worksheet Functions | |||
COPY/PASTE/FORMULA GIVES ABSOLUTE REFERENCE | Excel Discussion (Misc queries) | |||
How do I copy an absolute column and relative row to the right? | Excel Discussion (Misc queries) | |||
copy absolute figures and not formula | Excel Discussion (Misc queries) |