sharepoint list

  1. brendalpzm

    Filter formula is not working

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

    SharePoint List Exported to Excel: Appended Local Columns

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

    SharePoint List and Power Query

    I have a SharePoint List that I am wanting users to be able to use as a dashboard. I am trying two different avenues. 1. Export list to Excel based off filtered conditions, but limited due to only being able to filter each field how I would like it. 2. Using Power Query, I can filter how I...
  4. K

    Delete rows with criteria inside a Table with data connection

    Hi folks, I need a formula to run through a sheet and delete the row IF column C contains the word "Closed" . The problem is that data is in a table which is connected ( 2 way) to a share point list. I have tried using auto filter,looping etc but it fails at the 'delete' line.:confused: Am...
  5. A

    Importing a Sharepoint List to excel 2010

    Hi all, I have a problem in importing a Sharepoint list to excel 2010 with vba.I googled for the code and I found something like this. Private Sub Workbook_Open() Dim objMyList As ListObject Dim objWksheet As Worksheet Dim strSPServer As String Const SERVER As String =...

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