We are aware of the issue with the badge emails resending to everyone, we apologise for the inconvenience - learn more here.

Forum Discussion

rehanabbasi's avatar
rehanabbasi
Explorer | Level 3
7 years ago

Importing Data in Excel from Dropbox

 I have an excel file on Dropbox. I want to import the data from this file to another excel file (which I want to share to others) via Get External Data - From Web feature. But whenever insert the li...
Microsoft Office
Share
Shared Links
Web
rehanabbasi's avatar
rehanabbasi
Explorer | Level 3

@Jay

I already tried raw=1 procedure but it tries to directly download the file instead of opening it and letting me select the table.

Jay's avatar
Jay
Icon for Dropbox Staff rankDropbox Staff
7 years ago

If that’s the case, then it won’t be possible to import the Excel file into the other Excel file.

  • rehanabbasi's avatar
    rehanabbasi
    Explorer | Level 3
    7 years ago

    After some it and trial, I was able to import the data but it is not updating in the new file when I make changes in the Dropbox file.

    • Jay's avatar
      Jay
      Icon for Dropbox Staff rankDropbox Staff
      7 years ago
      Are you saving changes to the Dropbox file directly? Is your link to that file ‘live’ (meaning a shared link, and not simply a downloaded file)?
       
      Likewise, how frequently does the second Excel sheet update itself to verify the info imported from the first sheet? Is it automatic, every minute or so, or do you need to have it check manually? This is more of an Excel setting though, instead of Dropbox.
      • rehanabbasi's avatar
        rehanabbasi
        Explorer | Level 3
        7 years ago

        @Jay

        Yes, I'm updating the file in Dropbox directly and am using a shared link. Moreover, I've set the new excel file to import the data automatically. I've also tried importing the data manually but to no avail. :slight_frown:

About Create, upload, and share

Find help to solve issues with creating, uploading, and sharing files and folders in Dropbox. Get support and advice from the Dropbox Community.

Need more support

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X or Facebook.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!