Excel 2010 'renumbering' forumla values on linked worksheets
Posted on 2011-09-09
Hi All -
I have a pretty basic workflow going on that I'm having issues with.
I have a database with values. These values are then pulled into an excel doc on a worksheet. Nothing formatted there - just a pure 'data' worksheet. Then I have another worksheet where I map in the =VALUE(Data!AC3)... in to the appropriate field. Well I have a bunch of these so I just drag the formula around so each cell is sequential in the formula. It works great. I can refresh it and it refreshes...
A new row is added to the source data.
Whenever this happens, the sequence on the formulas skips a number, so instead of going from =VALUE(Data!AC3) to =VALUE(Data!AC4) in the next cell it goes =VALUE(Data!AC3) to =VALUE(Data!AC5)
I have no clue how to fix this as I've never seen it happen before.
Any ideas why??? Any ideas on how to fix it??
It's Excel 2010 and MS SQL Server 2008 R2 RTM.
Thanks in advance!