• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Automatically update formulas in table

M

marcvanderpeet12

Member
If you have turned your data into a table then formulas should auto populate the new row
 
Thats what I thought as well but I didnt manage to do it. Im using excel 2003, might that be the case? I attached the sheet. The relevant sheet is "Procespers. DLT"
 

Attachments

  • KodM - KPI.xls
    237.5 KB · Views: 6
Hi, marcvanderpeet12!

First of all I have to download this for being able to give a look at your uploaded file:
http://www.oakley.com/airwave

Now safely protected against the aliens embedded into the workbook, I think that the issue is that in columns J:K there are formulas that raise errors and both use this function:
NETTO.WERKDAGEN -----> in english: NETWORKDAYS

In other columns with formulas, like O:Q, or with data validation, like E & M, everything is working fine with the structured table List1.

If I could see the Dutch (original) function name instead of my localized Spanish version name (DIAS.LAB), that's because your Dutch version wasn't capable of translating it correctly into English (in fact to the internal code used). The cause surely is that in the machine where the workbook was saved the complement Analysis Toolpack isn't enabled (that's were the function actually resides), so try enabling it from the menu (please don't ask me where were those features in 2003 versions because I can hardly remember where are they in 2010/13).

Just advise if any issue.

Regards!
 
@NARAYANK991
Hi!
All other formula columns work properly, I tested them adding new rows and the table features behaved as expected, except for those not translated ones; so I'd discard the extend data range options, since the non working columns are between other working columns.
Regards!
 
You must log in or register to reply here.
Back
Top