• 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.

External Data Calculated Columns not always filling down table

F

Fran Reed

New Member
Hi all - I do a lot of external data connections and often times need to add a calculated column or two to the resulting table. I am finding that Excel is not filling in the formulas down the table which is frustrating cause they are important to the overall report. Sometimes, it fills down beautifully, other times not. I use Excel 2010 and 2013 and am experiencing same thing. Any ideas on what causes this? Otherwise I am stuck writing a quick macro to make sure that all of my data rows have the formula they are supposed to. Thanks
 
Hi Fran,

Not sure but here are some pointers,

Is it a TABLE or an array of data, with a TABLE, you may have to click on the Autocorrect arrow (Overwite all cells in the column with this formula) that appears after you enter the formula.

cheers

kanti
 
Thanks Kanti,
Generally when I set up the formula, I do check that formula is autofilled. And use the "autofill" button is needed when the formula is first generated. The dropdown you show is for 2013 but there is a "square" to hit on excel 2010 which does similar job.
Its the refresh that causes an issue. The challenge is that it works beautifully some of the time. I haven't found a pattern to indicate when it might not work. Otherwise, I can't expect clients to keep checking the tables to see if all of the formulas have filled in appropiately. very frustrating..
 
Hi Fran,

Sorry cannot offer any further suggestions, but I have come up against this inconsistency as well and cannot explain it.

cheers
kanti
 
Hi Fran,

Always good to know you are in good/bad company.

Let us know if you need help with the VBA
 
You must log in or register to reply here.
Back
Top