Question

Locked

Desperate for help with fixed cell references

By jeremy.thornber ·
I have a access data base which i import different information into tables in excel on a monthly basis. Excel then peforms some calculations to get the data in a format i want.
This information is supposed to appear on a master table within another excel workbook, obviously using fixed cell refernces.
The problem is that everytime i update the link between access and excel the master tables fixed cell refernces change.
e.g At the moment in a worksheet called OA i have the formula in A3000.
=AVERAGE($A$3:$A$2999) in my master table I have =IF('S:\SalesForce CRM System\Reporting\Forecast Model\Cycle Times\[Cycle Time Import Sheet 2.xls]OA'!$Q$3>0,'S:\SalesForce CRM System\Reporting\Forecast Model\Cycle Times\[Cycle Time Import Sheet 2.xls]OA'!$A$3000,""). When I update the link between access and excel the last part of this formula changes to $A$2997 or another random number. Any ideas as I thought a fixed cell reference shouldn't change?

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums