Thanks, your tutorial is really great and covers all the struggles I stumbled
through when figuring out how to work with tables ... would that I'd known of
it back then!
However, the problem I'm encountering is that =SUM(ABOVE) in tables which
worked fine in Word 2000 on the PC do not work when resaved in Word for Mac
2008, whether saved in Word 97-2004 format or in Word .docx format. Nor in new
tables that I create. The formula gives the appearance of working but the sum
is incorrect. I know I've hit the cell where he problem will start because
instead of presenting the formula =SUM(ABOVE) as for the preceeding cells, it
simply presents the =. From that point on, the formula does not work correctly
although it does present a sum result. I thought it might be some sort of
limit on the count of items the formula will sum in Word for Mac 2008; in
three of the tables, the problem point is occurs at row 85 and in one table at
row 84...close but not exact.
In the row 84 table, which I converted from PC to Mac, I detected a pattern in
which the =SUM(ABOVE) began to SUBTRACT the numbers, in order, from the start
of the column! So, for example, in row 87 there would be a subtraction, from
the sum valid in row 84, of the numbers in the column's rows one, two, and
three. And so on. But that pattern did not hold in the other tables. These
columns contain only numbers; any numbers in headers are spelled out. No
nested tables, split cells, or merged cells. And again, it worked fine in Word
2000 PC, with columns that were several hundred rows in length. I'm very
perplexed.
If you're using a formula like {=SUM(ABOVE)}, there are numerous reasons why
this might not give the expected result. For details,
plus info on doing a wide range of calculations in Word, check out my Word
Field Maths Tutorial, at:
http://lounge.windowssecrets.com/index.php?showtopic=365442
or
http://www.gmayor.com/downloads.htm#Third_party
--
Cheers
macropod
[Microsoft MVP - Word]
wrote in message Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I
create extensive tables in Word and use the formula
function to add columns for totals. This worked great on the PC but on the
Mac there seems to be a point at which the formula
"deactivates" and all that shows in the cell is the equal sign. I can type
in the formula but the result it gives me is wrong. I
cannot find the pattern in this. I thought at first it was an issue with
converting a PC file to a Mac file but I encounter the
same problem in files I create fresh on the Mac (.docx) as well. I need this
functionality for my work ... anyone know what's
happening or have any solutions?