Forum Discussion

marietuttle1973's avatar
marietuttle1973
Brass Contributor
Aug 08, 2024

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.

  • marietuttle1973 

    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

    • marietuttle1973's avatar
      marietuttle1973
      Brass Contributor
      This 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.

Resources