Forum Discussion
help with formulas for connecting 2 workbooks & connecting the sheets within it to sync new entries
i need help "linking" or connecting a sheet in 1 work book to 1 in another workbook the first workbook is a excel sheet of microsoft forms responses with the exact same column headings as the form o...
I would use PowerQuery to pull in the entire table form the form responses. Then I would use pivot tables (or more power query queries) to create the separate tabs. Note however, that refreshing the data will potentially zap any comments you add!
- isnt there just a way to link to workbooks together when one is updated the new updates post to the other workbook sheet?
or do I have to do it by coluns/row for new reponses?
i just want a copy that dosent get edited in case something goes wrong I still have the origonal input responses- have to do it by coluns/row for new reponses?
what do you mean new response?
After download from Ms Form and append the downloaded records to an exist worksheet? I second JKPieterse 's PowerQuery recommendation.
If you're looking to essentially pull all the form responses from another workbook (and have it update), PowerQuery is the way to go:
Import data from data sources (Power Query) - Microsoft Support
Excel can fetch the data easily with worksheet functions but when the data is in an external workbook it takes dynamic array functions off the table because the source would have to be open.
Another possible option is a PowerAutomate flow to move data from table to table but at that point you might as well go with the simpler approach in PQ and call it a day.
