I am having trouble linking to an excel spreadsheet(or even importing it) from a shared network folder on our coporate network. I have tried two different ways. First I mapped a drive for the folder containing the spreadsheet, then I tried just using the UNC path to the file, I get the same error both ways. The error basically says access cannot find the path to the file, but it adds a pound sign(#) to the end of the filename instead of the excel extension(.xls) so I get an error like this:
using a UNC path I get excel cannot find the file \\networkshare\somefile# the actual path is \\networkshare\somefile.xls
I get the same error using a mapped drive" excel cannot find the file G:/somefile#
It is obvious that access can see the file because I can navigate to it wioth no problem but it removes the extension and adds "#"