source file

Hey guys, I have a file with a lot of linked data, which can't find any data via the Vlookup function when the source files are closed. It works perfectly until I decide I want to sort the data in a different way, which is when I get #REF! errors all over the place. However, when I open the...

Hello everyone, I am struck with this problem since yesterday and have been unable to find any solution despite all the web searches. Please help me if it is indeed possible. To better explain the situation: We have multiple templates for different product types (400+). We share these files...

Hello, The issue: At my company, we utilize SharePoint co-authored Excel workbooks to retrieve, store, and manipulate data. Aside from that being problematic in and of itself, users want to see populated data in one workbook based on data from another workbook. Essentially, a formula looks like...

Dear All, I have a destination workbook which is protected and as well as the worksheets in it. I have source workbook with only one worksheet (which is also protected) which will be updated by someone else. Source file is saved in such a way that I have only READ access. I want my formula in...

Help please! I have a workbook that is vlooking up to another workbook. The issue is that when I open up the WB that has the vlookups, it gives me the update links dialog box (which is fine). When I click update, I then get an error box that it cannot update the links and #refs everything...

Hi all, I'm trying to update the links to a new file and Excel 2007 is saying "xxxxx file cannot be found. Please check your spelling or try a different path". The file path is definitely correct. No folders have had their names changed etc. The file was used a new user who has her network drive...