sharepoint

I have many worksheets stretching back several years with cells containing hyperlinks to PDF documents. Those documents are held on my OneDrive account. The links were created to point to the local version of the files (sync app is functioning correctly) However those links now point to the...

Hello. Can someone please help me? I uploaded my dashboard in a sharepoint/one-drive but when I open the file, the slicers are not working and I am getting this red error notice.

I have created a file that my coworkers use to pull information from and the file is stored on SharePoint and accessed by them either via Teams or the desktop app. Seeing that several people might access it at the same time - is there any way to set it so that they can only see their own...

Hi, I need VBA code to get the list of top 10 recently modified files on the excel ribbon as macros in excel ribbon. The list of these files must be obtained from the Sharepoint link.

How do I resolve this exception thrown while trying to do CRUD operations on CSOM? Let me break this down for you. CRUD, of course, means "Create Read Update and Delete". CSOM is the tech for connection C# to a Sharepoint List (or, I assume, also a Microsoft List) in order to...

Hi All, Not sure if this is the right place to ask this question but it is about Power Automate At the moment - I receive an email which has a recording (attachment) in the format of MP3. I have a power automate flow which detects when i receive an email containing the certain subject line...

I have a sharepoint list where items are input from a form (List1) and another list with users and emails (List2). I want the flow to check whenever an item is created in List1 and look up in the List2 and get all the emails that are classified as Admin in the column Profile and send an email...

I am creating a week view calendar with a vertical gallery, This gallery is linked to a SharePoint list where I have the date slots until july 20, 2024. I applied a filter to the gallery to show only the 7 days according to the month showing. The issue is that when I change to the next...

I am working on a VBA file that has a button, which should upload some data from an Excel file to a Sharepoint file. The problem is when the Sharepoint file is open it takes 2/3 times to run it to upload the information. But I want the data to be uploaded whether Sharepoint is open or not. This...

I have one Excel Online document that has a data file. I have another Excel Online document where I am wanting to use the Workbook Links feature to import the data from the other data file. An issue that I am running into is if the original data file is updated with new rows, the other document...

I am developing a power apps site, for this I am creating a booking site I created a list in share where I located the available slots for the day I type the formula for filtering the slots only to show the slots available for the selected date and also to be greater than the current time but...

Hi all, Hoping someone can help me figure out a solution - ive checked a few posts and cant seem to get the right bits for what i need to figure this out myself I currently have this VBA code that works perfectly, however, if others are wanting to use this report, as they dont have access to...

Our Excel files are stored on SharePoint Online and they are very picture-heavy. Some files reach 300MB and we need a way to reduce the file size. If I run the Save As command I can get to the tools menu to compress images and bring a 300MB file down to 100MB, but how do I do this with VBA? I...

Good afternoon I have a number of Excel files which use VBA to create 'dynamic' filepaths, which then proceed to do whatever is needed of them For example: Var1 = [directory root] Var2 = [month] var3 = [Filename] FullFilePath = Va1 & "\" & Var2 & "\" & Var3 ... and then the rest of the script...

Hi Everyone, I have a 30 column table in excel, and the first 6 columns are getting data from a sharepoint list connection, however when I delete or add a row in sharepoint list only the first 6 columns of the table are being removed/added and the other columns are just shifting up/down. How do...

I saw this old thread Automating Importing IQY Files and used that code as well as recorded my own macro. Here is my code. Sub Macro1() Workbooks.OpenDatabase Filename:="C:\New folder (2)\Data\Test2.iqy", _ CommandText:=Array( _...

I'm guessing i just need a fresh set of eyes to look at this. I have some pdf files on my c:drive that i am wanting to move to sharepoint. I have other code in which i save directly to sharepoint and it works fine. I ran a test to see if i can save to another folder in my C:drive and it works...

Hello, I have a spreadsheet on Sharepoint that I'm trying to make work. The purposes: To allow people from our building can add their name and birthdays. To have conditional formatting that automatically highlights all rows containing dates from the current month. To automatically populate...

Hi. I wanted to share the same data across many workbooks to maintain data integrity. Any ideas??

Our company uses Onedrive for our team file distribution. All work is done locally and then files are synced up when wifi is available. I have a few macros built in to our files to ready them for client distribution. The problem is sometimes the files get overwritten after the macros run and we...