sharepoint

I have a Microsoft form that is writing data to an Excel spreadsheet in SharePoint. The for adds a new row when a submission is added. However, the data is submitted as text. I would like to be able to automatically convert to numbers so that my dashboards work appropriately. Does anyone know of...

Just wondering if anyone can help... We have an old excel workbook that runs some VBA code, however we have recently moved to a SharePoint system and the macro now fails.... I have tried replacing the code (sarting W) but having no luck. This is the bit of code in question file.CopyFile...

Hi all, Hope someone is able to help me with a macro that has given me some headaches already. What my macro does is basically the following: We have a list of line managers, in case a new one comes in we want to make sure that that person is taken into account in the masterfile. Since we are...

I have a rather complex Excel workbook with many complicated array formulas, pivot tables and charts, and macros that I share on Teams using the Excel co-authoring capability. Of course, since the workbook contains macros, my concurrent users are opening it in the desktop app. The workbook...

Hi All, Cannot get my head around this issue. I have a Powerapps form that opens on a Sharepoint list when adding/editing a list item. One of the fields auto populates the current users name into a field which is working great for new entries. However, whenever I open a list item to view or...

We are working with a local excel file where everyone in our company can add data if they have the password of the file. Now we need to publish a copy to a sharepoint site with only a few members having access to that sharepoint. The sharepoint copy is needed for a power query run on it for...

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...