Forum Discussion
Formulas
I have 3 workbooks in Excel. I have a Master PO Number Spreadsheet and a spreadsheet for each of my project managers. I was originally working on these and had them saved to my flash drive. Now I have them saved on my computer in a folder on our dropbox. Now my formula is not working because it's looking for my flash drive. How do I adjust the formula to look on the dropbox and where to look? Spreadsheets are attach for reference. You'll notice in the individual spreadsheet for Kyle, each column the formula is looking for E:\Marie - that was my flashdrive. How do I change that to the dropbox file? I'm not sure what all to type in. I know where the file is.
You'll have to replace the path E:\Marie with the path of your local Dropbox folder. On my computer it looks like
C:\Users\<username>\Dropbox
- marietuttle1973Brass ContributorThis is the path directly to the file. When I replace it with this, I get an error
Path to location of files
C:\Users\Maura\J&M Commercial Dropbox\Sales and Bid Documents\TEST\
Error:
Excel found a problem with one or more formula references in this worksheet.Can you post an example of a complete formula?