We're making changes to the Community, so you may have received some notifications - thanks for your patience and welcome back. Learn more here.
Forum Discussion
Referencing Excel cell in another excel spreadsheet.
Hi. I'm trying to display the contents of a cell (cell A1) from one excel spreadsheet (spreadsheet1) in another excel spreadsheet (spreadsheet2). I just can't get it to work. I sometimes get a 404 error. I'm creating a link for spreadsheet 1 and trying to put it in a cell in spreadsheet2. This is the code I'm using in the cell in spreadsheet2:
='dropbox link from spreadsheet1'!A1
Any ideas on what I'm doing wrong?
Thanks
- Rich
Super User II
KarenCn wrote:
I'm trying to display the contents of a cell (cell A1) from one excel spreadsheet (spreadsheet1) in another excel spreadsheet (spreadsheet2). I just can't get it to work.Are you planning to share these files with anyone, or access them through the Dropbox website? If so, you won't be able to link files like that.
When linking files in an Office product, the full path to the file is used. This is fine for files you access yourself on your own computer, but if you share these files the paths will be different for other people, and Excel wouldn't be able to find the linked file. The same holds true if you were to try viewing the files on the Dropbox website. Excel wouldn't be able to locate the linked file.
This isn't a Dropbox issue. It's more a limitation to how linked files work in Office.
- Okay. Thanks for your response. I'm not trying to share the files with anyone else. What I'm trying to do is reference a value from one excel spreadsheet in another excel spreadsheet. Both excel files are stored in Dropbox. I thought I might be able to create a link from the first spreadsheet and then reference a cell from the first spreadsheet (using the link) in the second spreadsheet. I thought I was using incorrect syntax but is it not possible to link spreadsheets in this way?
