Cannot download the information you require

[Cpreston]

Hi

We have 2 spreadsheets on a SharePoint. One updates from the other. But we are getting a message saying Cannot Download the information your requested with the path in front of it.

There is only one formula pointing to the other spreadsheet and as the formula below

=IFERROR(VLOOKUP(B4,'

https://howarthtimbertrial.sharepoint.com/sites/AFP/Master

Lists/[MDF Products.xlsx]Top Tier'!$B$6:$C$20,2,FALSE),"")

The path is exactly correct and if I go into Edit Links I can actually open the source. If we have the source open and then open the other sheet we don't get an error message.

Any ideas why when opening the spreadsheet I am getting the error message and how can I fix it.

Thanks

 

[SkipVought]

Hi,

Can’t comment directly to your question. However, I recommend against using lookups referencing another workbook. Its just not a sound design approach, IMNSHO.

My preferred approach would be to create a table via MS Query that imports the referenced table into your working workbook. This table can be Refreshed at any time to maintain current data. Then perform the lookup within your workbook. This is much safer, direct and maintainable.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]