FILL function not working when linking multiple workbooks

[Joe G Hoover]

I have spreadsheets set up in multiple workbooks. One for each department. Each spreadsheet ties into my master. It is set up this way so each department can fill in their info but not see the other departments info at the same time. The master grabs all departments info. In the master I have the following formula Example:

='A:\Resorts\Labor Report\[Themes Labor Report.xlsx]2017 - Weekly Labor'!$AK$4

When I try to use the FILL function dragging this formula down on my master spreadsheet it is not auto calculating and instead just copying the same exact formula. I would like to see it auto calculate as it does when working in the same spreadsheet......like this:

Weekly Labor'!$AK$4
Weekly Labor'!$AK$5
Weekly Labor'!$AK$6


So far the only way I have been able to do get it working is by manually changing each formula in the master. Is there a better way to do this or a trick I don't know about?

Thanks,
Joe

[CK76]

Just remove the "$" signs from cell reference. Which is absolute reference and prevents cell reference from changing when dragged down.

Something like below.
='A:\Resorts\Labor Report\[Themes Labor Report.xlsx]2017 - Weekly Labor'!AK4

[aditya88]

='A:\Resorts\Labor Report\[Themes Labor Report.xlsx]2017 - Weekly Labor'!$AK4

change $AK$4 to $AK4, then you'll be able to drop it down.

[Joe G Hoover]

That worked. You are both my hero's today. Thank you.