Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
SUM refering to a second table is not working any more
Hello,
nice forum here. I have a old Word .doc with some (2) macro in but it is not working any more. The .doc contains 3 tables 1 tabel for header (Table 1) 1 table for product pricing (Table 2 named POSITIONEN) name of prod., number of prod. and price per each which is calculated to a price per line 1 table which grep the colume where the price per line is calculated and sum it up Table1 has 4 colums Table2 has 6 colums Table3 has 2 colums The formula I use in Table3 B1 is: =SUM(POSITIONEN f:f) \# "#.##0,00 ‚¬;(#.##0,00 ‚¬) But all I get is !Syntaxfehler, : ##################### Thank you for your help. Bernhard Stillger, Germany |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
SUM refering to a second table is not working any more
"Bernhard" wrote:
Hello, nice forum here. I have a old Word .doc with some (2) macro in but it is not working any more. The .doc contains 3 tables 1 tabel for header (Table 1) 1 table for product pricing (Table 2 named POSITIONEN) name of prod., number of prod. and price per each which is calculated to a price per line 1 table which grep the colume where the price per line is calculated and sum it up Table1 has 4 colums Table2 has 6 colums Table3 has 2 colums The formula I use in Table3 B1 is: =SUM(POSITIONEN f:f) \# "#.##0,00 ‚¬;(#.##0,00 ‚¬) If it used to work and it doesn't anymore, I think you will agree that it means something has changed. Have you tried to change the formula? Have you modified Table 2 in such a way that the bookmark is not where it should be anymore? Have you changed Office/Windows Version? Have you changed the system language? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlink not working in table | New Users | |||
Shading is not working on a large table. Why? | Tables | |||
Table AutoFit Not Working | Tables | |||
form fields not working in a table | Tables | |||
Table of contents not working | Microsoft Word Help |