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?
|