Skip to main content

Posts

Showing posts from December, 2019

1904 issue when data is extracted from the SharePoint list.

We have an option in SharePoint to export the SharePoint list to an excel.  When a user extracts a report and enable the "user 1904 date system" under Excel Options-> Advanced->When calculating this workbook,  the data columns in the excel would get added by 4 years and 1 day. For example: If the date column has the value 08/03/2019, it would get converted to 09/03/2023. Please click here to know more about the excel date systems. Please follow the steps to correct the shifted dates! Correcting Shifted Dates If you link from or copy dates between workbooks, or if you change the date system for a workbook that already contains dates, the dates may be shifted by four years and one day. You can correct shifted dates by following these steps: 1.     In an empty cell, enter the value 1462. 2.     Select the cell. On the  Edit  menu, click  Copy . Note  In Excel 2007, select the cell, and th...

Hide SharePoint List View based on User Groups

There is a requirement where the users should be allowed to view only the requests raised by them and a particular SharePoint group members should be able to view all the items. We can achieve it using Rest API but a much simpler approach would be to make use of the OOTB features. 1. Please create a view with filter "Created By" is equal to [Me] and make it as the default view. 2. Now navigate to the list view page. Edit Page. Edit web part and check the option "Disable view selector menu" and save the webpart. This would prevent users from selecting the view. In simple words, the user would be able to see only the list items and not the view tab. Now, how to  make all items view visible to the members of a SharePoint group. Please go to the navigation settings and create a link to navigate to the all items view. Set target audience to the particular SharePoint group. Its done! :)