How to change underlying formula for Excel Table?

[Ashish Naik]

Hi,

I am using Excel Table which has formulas. I have added 300+ rows and realized some of the formulas are incorrect.

Whenever i add a row, i have to manually make correction to formula in the new row.

How do i change underlying master row that excel uses to create new row?

Cheers
Ashish

 

[bobhc]

Change the formula (probably at the top of the table) and then double click bottom right to send the formula down.

 

[Ashish Naik]

No it doesn't help. Already tried that.

 

[bobhc]

Perhaps you could use the "Upload a File Button" so we can see what is what.

 

[Somendra Misra]

Hi Ashish,

How about changing your table to range change the formula in top row copy down and than convert back to table.

Just try it, or else upload your sample file as @bobhc suggested above.

Regards,

 

[Ashish Naik]

@Somendra, changing to range and back to table didn't work.

i cant share the sheet as it is confidential. Tried to create a sample sheet but could not replicate the problem i am facing. So little confused.

However, work not hampered so won't spent much time on this right now.

Thank you all for suggestions.