I have successfully created Dynamic Ranges to access excel data that is
constantly changing in the number of rows.

It only seems to work if the data spreadsheet is open. I've used the Browse
button to specify the exact location of the spreadsheet, but it won't hunt
for it correctly on the network.

Any suggestions?