We have been collecting customer surveys for some time and decided to revise both the survey and the target spreadsheet.
Basically, we cloned the original survey (#1), removing a question no longer needed.
We created a new Excel connection to the clone (Survey #2) and got clean data in Spreadsheet#2. We added a number of pivot tables to this sheet, and everything looks good.
Now, we want to re-create this arrangement for another employee. Rather than recreate all these pivot tables, can we CLONE Survey #2 and Spreadsheet#2?
In other words, can we connect a new survey to an existing spreadsheet?
Note: we don’t have to import existing data. Nice to have, but not critical.
Best answer by john.desboroughView original
just tested quickly again and nope .. could not do it..
@KDandenell No, I’m afraid this isn’t possible with Excel. You will have to create a new sheet to use this integration.
HOWEVER, Microsoft doesn’t like you to connect spreadsheets online with constant data flow. They—serioiusly—want everyone to log in from a desktop app rather than have the data refreshed automatically. That basically kills the usefulness for me. The entire purpose of the exercise was to allow staff to use browsers on desktop or iPads to see customer feedback in real time. Doesn’t really work if they have to log in and refresh manually.
The only real workaround is to hire a DBA to use a proper database that renders the results in HTML, but we don’t have time or budget for that.
Way to go, Microsoft.
if you have the option, try google sheets.. you can do it one sheet with separate tabs.. just a thought
An excellent thought!
Let us know if you end up giving that a try,
It’s dead, Jim. That doesn’t work.