shared folder

Hi everyone, I have excel spreadsheets saved in a shared dropbox folder so that myself and colleagues can access and update. I have entered formulas to pull in information however its looking on my C drive which obviously returns an error when a colleague opens the spreadsheet. Current...

I apologize if this is covered elsewhere. I searched, but could not find a good solution. Our company uses DropBox to sync and share folders between employees. We store Excel workbooks in these folders. We are having issues when using formulas in one workbook that link to data in another...

Here's my situation: I have a master workbook file that has links to a feeder workbook. Master file and feeders are in the same folder. As I have developed this file I have kept it local on my computer. Locally, when I update one of the feeder worksheets, the master sheet is updated...

I have seen some macros that can tell you if a shared FILE is in use by another user, but is there a way for the macro to tell me if a ANY file on a shared folder is in use. I don't really need to know the name of the file, just that SOME file on that folder is in use. Here is the code for a...