How can I merge and link workbooks into one summary workbook? in Excel Worksheet Functions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Sylvia 8/23/2005 2:06 AM PST   Question   hello! I am desperate - I need to link several workooks from different departments together to create one summary workbook that is automatically updated.. Can anyone help? If I just do "paste link" the format is different and it doesn't really work. In the best case this should be a mutual link - if the summary is updated, the source documents should be as well. is that possible? Thank you! Sylvia     Was this post helpful to you?         Reply |   Top           Duke Carey  8/23/2005 4:59 AM PST   Answer   Links are one-way only. You can "pull" info out of a cell in another workbook, but you can't "push" new data back into that cell, at least not without writing VBA code to do it. If your main objection to what you are currently trying to do is the lost formatting, then add an extra step to the process: after you've completed the 'paste link' step, go back into Edit->Paste Special... and paste formats. "Sylvia" wrote: > hello! > > I am desperate - I need to link several workooks from different departments > together to create one summary workbook that is automatically updated.. > > Can anyone help? If I just do "paste link" the format is different and it > doesn't really work. In the best case this should be a mutual link - if the > summary is updated, the source documents should be as well. is that possible? > Thank you! Sylvia     Was this post helpful to you?         Reply |   Top           Christine 7/31/2008 1:51 PM PST   I have 50+ workbooks that are identical in format. I would like to create 1 summary workbook without opening and clicking on the first cells in all the workbooks and copying the formula to all data cells on each of the sheets. Is there a way to sum the same cell in all the workbooks accross all data cells on each tab without manually clicking each link? The summary file would automatically update when changes are made to the 50+ detail workbooks. "Duke Carey" wrote: > Links are one-way only. You can "pull" info out of a cell in another > workbook, but you can't "push" new data back into that cell, at least not > without writing VBA code to do it. > > If your main objection to what you are currently trying to do is the lost > formatting, then add an extra step to the process: after you've completed > the 'paste link' step, go back into Edit->Paste Special... and paste formats. > > > "Sylvia" wrote: > > > hello! > > > > I am desperate - I need to link several workooks from different departments > > together to create one summary workbook that is automatically updated.. > > > > Can anyone help? If I just do "paste link" the format is different and it > > doesn't really work. In the best case this should be a mutual link - if the > > summary is updated, the source documents should be as well. is that possible? > > Thank you! Sylvia     Was this post helpful to you?         Reply |   Top           Ron de Bruin 7/31/2008 1:58 PM PST   Try the example here http://www.rondebruin.nl/summary2.htm Or if you only want the values try the add-in (very easy) http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Christine" <Christine@discussions.microsoft.com> wrote in message news:88DD8E4D-3A49-4E1B-8E40-C65788AF2C77@microsoft.com... >I have 50+ workbooks that are identical in format. I would like to create 1 > summary workbook without opening and clicking on the first cells in all the > workbooks and copying the formula to all data cells on each of the sheets. > Is there a way to sum the same cell in all the workbooks accross all data > cells on each tab without manually clicking each link? The summary file > would automatically update when changes are made to the 50+ detail workbooks. > > "Duke Carey" wrote: > >> Links are one-way only. You can "pull" info out of a cell in another >> workbook, but you can't "push" new data back into that cell, at least not >> without writing VBA code to do it. >> >> If your main objection to what you are currently trying to do is the lost >> formatting, then add an extra step to the process: after you've completed >> the 'paste link' step, go back into Edit->Paste Special... and paste formats. >> >> >> "Sylvia" wrote: >> >> > hello! >> > >> > I am desperate - I need to link several workooks from different departments >> > together to create one summary workbook that is automatically updated.. >> > >> > Can anyone help? If I just do "paste link" the format is different and it >> > doesn't really work. In the best case this should be a mutual link - if the >> > summary is updated, the source documents should be as well. is that possible? >> > Thank you! Sylvia     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies