melizabeth
New Member
- Joined
- Jan 20, 2011
- Messages
- 1
I have several templates that analyze data using charts and tables. I was challenged to "speed up" the process - therefore, I used "data from other sources" to link workbooks that are out on a shared drive to quickly access current data.
My most complex template has 48 links. The linked data feeds 8 summary pages, each holding 8 charts and 8 tables. Linking appeared to be a great solution. However, when I "refreshed" the linked tables, the formulas in the tables migrated down 1 - 2 rows.
When I googled this problem - I found one source that suggested INDIRECT FUNCTION can be used to solve this challenge.
I have been watching Excelisfun YOU TUBE videos to learn about INDIRECT. However, I do not know how to apply the INDIRECT function to this situation.
There are over 50 worksheets in my most challenging template - and formulas similar to this one: =IF(ISBLANK('A(1)'!A12),"Elasticity n/a",'A(1)'!A12) - that bring in the data into the charts using the linked tables.
Is INDIRECT the function that can help to solve migrating formulas? If so, how do I apply it to my template?
My most complex template has 48 links. The linked data feeds 8 summary pages, each holding 8 charts and 8 tables. Linking appeared to be a great solution. However, when I "refreshed" the linked tables, the formulas in the tables migrated down 1 - 2 rows.
When I googled this problem - I found one source that suggested INDIRECT FUNCTION can be used to solve this challenge.
I have been watching Excelisfun YOU TUBE videos to learn about INDIRECT. However, I do not know how to apply the INDIRECT function to this situation.
There are over 50 worksheets in my most challenging template - and formulas similar to this one: =IF(ISBLANK('A(1)'!A12),"Elasticity n/a",'A(1)'!A12) - that bring in the data into the charts using the linked tables.
Is INDIRECT the function that can help to solve migrating formulas? If so, how do I apply it to my template?