Publish and Sync Sharepoint Lists using Excel 2010

Capt.Ragnar

Board Regular
Joined
Jun 6, 2012
Messages
138
Alright gents:</SPAN>

I have searched and searched for a solution/work around for this issue, I’m hopeful someone smarter than I can produce an option that will satisfy the quandary described below…
</SPAN>
I have authored a spreadsheet that performs various analyitical tasks and compiles a summary report in table format that is then published to Sharepoint as a List. The problem occurs that at the point in time the sync occurs. All cell references to source data within the table are converted to values just before the sync and then remain as values afterwards.
</SPAN>
Subsequently, I’m left with a table that is values only in a report that must be updated monthly.</SPAN>

Is there a macro/setting/option that would allow the table to preserve the formulas and still sync values to SharePoint?

At current, I’m considering a simple copy and paste of an identical table each month over the table being sync’d to sharepoint to reflect the updates. </SPAN>

Any help is appreciated.

</SPAN>
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Upvote 0
I'm using the 2007 add-in. Did you not experience the same issue with the tables converting to values only post sync?
 
Upvote 0
Yeah, unfortunately the issue is by design and I was never able to find a functional way of getting around it.
I've seen a few commercial applications that claim they work but I've never tried them since the corporation would probably not pay for it anyway.
In lieu of that, I've just modified the way I update data, i.e. some of the data I keep as a full spreadsheet which each user has to open locally or if its quasi dynamic data I just update it and sync it to the list or table.
 
Upvote 0

Forum statistics

Threads
1,211,710
Messages
6,103,452
Members
447,866
Latest member
bowers261

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
Back
Top