sharepoint

My company has foolishly decided to use Microsoft 365 web edition. Because of this we are not able to use macros. This is because of SharePoint limitations. Is there a way to count how many times a cell is clicked without using VBA or macros? I should also mention this is being run as a shared...

Hello, I've got an issue with FIleCopy command in VBA. I always used this when i wanted to copy/paste some file from one folder to another. (but it was local or based on the server). Unfortunately at that moment i have to wokr with onedrive solution. I need to build some file (or rather wanna...

Hi Hope you can help me. I’m trying to create an excel data-entry form using VBA to capture data and -- when submitted -- paste the data onto a separate tab on the spreadsheet. This is what I have so far. This form will be used by my colleagues when they collect information from customers...

Hi everyone, I know Microsoft recently changed their rules about using macros on files on sharepoint, has anyone managed to get around it? I've tried adding it as a trusted site but it still doesn't allow it. Thanks in advance for any advice!

Hello I have an Excel spreadsheet saved on my Sharepoint called "SRQ.xlsm" which I am trying to run the VBA script below, however I am getting the run time error "Error 52 Bad File Name". When I try it in my own local drive, I can run it perfectly. I have already looked at different...

Hi, My company has a large excel file shared on a SharePoint between 20+ people and it very often we have "Can´t merge your data..." making us to rework the change again. I was wondering if Excel has the ability to "listen" to changes on a shared file so that we can prevent the save until...

Hello, I am trying to create a column where there is a drop down list in each cell and have the ability to select multiple options. I know how to get the drop down list with data validation and I found this page that allows me to successfully select multiple (without repetition) with a VBA...

Hi I have a SharePoint list exported to an Excel table which I'd like to keep as a live connection by using Data > Refresh All. I'd like to lock the table so it cannot be sorted, but that it can still be filtered. I tried this through Sheet Protection (only blocking sorting but allowing...

Hi all I have a SharePoint list exported to Excel – and I’ve appended some Excel columns with some comments which I have to keep local on an Excel file and can’t go into the original SP list. This works ok except when the SP list columns in Excel are sorted and then refreshed – which leads to...

Hello experts, I have the code below which updates some columns of SharePoint list, based on excel values, through its ID in a loop, however if I have hundreds of entries it take some time intil updates, so I would like to know with you can help with improvements in the code. It uses SQL...

Good morning, I am trying to get data from an excel file saved on Sharepoint, but I get the error message 'We couldn't authenticate with the credentials provided' when trying to connect anonymously. I am using Office 365. Does anyone know how to grant anonymous access? Many thanks, Paul

Hi everybody, I am Paul, and I recently joined that forum. I would like to share to other computers an excel file which contains formulas to fetch live quotes from Bloomberg. My idea was actually to push to OneDrive or Sharepoint a copy containing only values and being updated with a Macro...

Hello, The issue: At my company, we utilize SharePoint co-authored Excel workbooks to retrieve, store, and manipulate data. Aside from that being problematic in and of itself, users want to see populated data in one workbook based on data from another workbook. Essentially, a formula looks like...

Hi there, I have a WFH workbook that has a different sheet for each employee to log there working from home hours. Using VBA I open a Planner workbook and colour a cell in the corrrect day to blue to indicate working from home. The problem I have is that the location of the 2 workbooks is now...

Hello, I have a file that has "missing Libraries" and gives the error "can't find project or library" on the most simple functions only when opened by other users. I have created an excel that runs several relatively simple Macros: Copypaste, print pdf and send emails. When I run it in my...

Hello all! Is it possible to have a workbook auto-protect the sheets, even as a live (auto-save) file on Sharepoint? Before uploading this shared workbook to Sharepoint, we had macros set to automatically re-protect all sheets in the workbook. I'm having trouble working out if this function is...

I have an Excel workbook that pulls data from several SharePoint lists on a Microsoft 365 tenant for ABC Company via Power Query. I have the exact same SharePoint lists exist at XYZ Company's tenant. I would like to have a button that programmatically switches the Power Query source from one...

How do I remove all these links to external templates? I've cleared names, broken links, gone through all my conditional formatting, and I cannot find the source of these templates to clear. They are associated with 365 login from my former employer and I no longer have access. Thanks

Hello, I have a sheet in a file which I would like to update automatically with changes. the problem is the file name changes everyday in the format of "AAAA01232022" to "AAAA01242022" so the change is in "mmddyyyy" format and progressing by one each day. Occasionally there are days the file...

Hi All Really hope that someone can help with this. I've spent most of the day trying... and failing. I have a few hundred PDF documents in a Shareholder folder and I'm looking to open them via an Excel hyperlink. The code below works when the files are saved on my local drive, but fails...