Link to external spreadsheet

Claire Mitchell

I would like to link to an external Excel spreadsheet that has multiple tabs.  I understand that I can attach the spreadsheet, but I'd like the ability for all our users to edit just one spreadsheet in real-time (vs. editing and re-attaching after each edit).  Is this possible?

Jim Hook

I don't think there is a way to generate a link to anything other than another Smartsheet or an external url so there is no easy solution to your problem. If you're not using Excel functions like pivot tables or nice charts you could import each Excel tab into a unique Smartsheet and link everything together within Smartsheet and then share the sheets with everyone on your team as editors. That might be a lot of work though depending on what each Excel tab does and how many there are.

SashaR

We have switched to used Google Docs instead of Excel. You can link a Google Spreadsheet directly to your sheet. When someone clicks the link, they are brought directly to the Spreadsheet were they can make their changes. You don’t have to worry about re-attaching it, since it will always be linked to your Smartsheet and you won’t have worry about file versions (its all saved with Google).