How to prevent Excel from uploading to SharePoint

USAMax

Well-known Member
Joined
May 31, 2006
Messages
846
Office Version
  1. 365
Platform
  1. Windows
I have users that need to disseminate data from files that are downloaded from SharePoint. My program does the job but the popup, "Uploading to SharePoint" slows down the process. When they are running wireless it almost complete stops the process. We do now want anything on SharePoint to be updated from our changes.

How do we prevent Excel from uploading to SharePoint in VBA?

Please note, I have seen a lot of users with the same problem with OneDrive so if you know the solution for this I would love to know this to but it is not urgent.
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Seriously, this is starting to get me upset!

I wrote a macro to copy values only from the data worksheet and then closed the workbook so I don't have any links from that workbook.
The workbook I have my program I copied over the values manually but I copied over the modules and it is still uploading to SharePoint.

Can ANYONE help?
 
Upvote 0
Has anyone else had or solved this problem??? I have a workbook that receives an error every time it closes because it is trying to upload to sharepoint.
 
Upvote 0

Forum statistics

Threads
1,221,310
Messages
6,159,176
Members
451,543
Latest member
cesymcox

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