Synchronising Excel Documents Across SharePoint

goobler

New Member
Joined
May 12, 2010
Messages
1
Hi guys!

I'm new to this forum, so apologies if this has come up somewhere else. Although I've had a thorough look around and I haven't been able to find the answer, so I'm hoping you may be able to help me. By the way, I'm fairly new to this level of Excel coding, so you may have to bear with me.

I was wondering if any of you knew how to synchronise and automatically update certain fields on a large summary Excel document from the inputted data placed in other smaller Excel files, all across SharePoint, without having to download the documents to the local drive and uploading them back up. Let me explain....basically we have a number of project-related files on SharePoint. The "Mac Daddy all encompassing Excel project document" compiles all the information from various different individual, smaller, process-specific Excel documents. Currently this is all done manually, which is obviously very time consuming. As far as I'm aware, you can't quite do a straight forward updating formula in SharePoint as you would do if all this was happening in my local drive.

So any ideas on how I can do this? Do I need to combine Web Query Look Ups into the macro that would make all this work? (Btw, I have no idea about how to use Web Queries, so if they are necessary, you may have to explain those a little bit). Ideally this updating would be done automatically upon saving/closing the updated smaller process-specific documents, and this would update the fields in the master file. Or even if its done by pressing an Update button that has the necessary macros/VBA coding imbedded in it. If you could explain it all in crystal clear terms and write the coding exactly as I would need to enter it I would be eternally grateful. Thank you very much in advance

I look forward to hearing from you soon guys!

Cheers
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Watch MrExcel Video

Forum statistics

Threads
1,123,176
Messages
5,600,147
Members
414,365
Latest member
UUR

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top