Insert row not coping all forumlas
 

I have about 100 calculated collums on a row. When I insert a new row, about
70 of the formulas automatically copy into the new row. How do i fix it so
all of them copy into the new row?

Thx

Insert row not coping all forumlas
 

I know there was a reply to this already but can't see it so...

check out this site

http://www.mvps.org/dmcritchie/excel/insrtrow.htm

Insert row not coping all forumlas
 

I had found that already but trying to figure out why some do and some dont.
I also found while doing some sorting that when i sort on collums and tell it
to expand selection that not everying is sorted.

It appears as if somehow excel has decided that each row is chopped into
seperate sections. Need to let it know the entire row is one record.


"D." wrote:

I know there was a reply to this already but can't see it so...

check out this site

http://www.mvps.org/dmcritchie/excel/insrtrow.htm