All About SharePoint and Other Technologies

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

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! :)

The global navigation can be handled through the navigation settings in SharePoint. The 'Navigation Settings' can be found under Site Settings->Look and Feel. The Navigation Settings would be enabled only if the 'SharePoint Server Publishing Infrastructure'   feature is activated.

Came across this error recently while creating a sub site using a custom template. "This web template requires that certain features be installed, activated, and licensed. The following problems are blocking application of the template: Feature Description Feature Scope Feature ID Problem ViewFormPagesLockDown Feature Site collection 7******3-0**4-4**d-9**a-7c175******4 Not activated" Solution: ViewFormPagesLockdown  is referring to the  Limited Access User Permissions Lockdown mode  feature. Please try to navigate to the site collection where you want to use the template to create a sub-site, then go to Site Settings>Site Collection Administration>Site Collection features to activate the  Limited Access User Permissions Lockdown mode  feature to see the result.

Get list of all solutions installed on the farm: [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") $farm=[Microsoft.SharePoint.Administration.SPFarm]::Local foreach ($solution in $farm.Solutions)         {             if ($solution.Deployed){                Write-Host($solution.DisplayName)                $solution.DisplayName >> c:\temp\test.txt             }                  } Get list of all features installed on the farm: [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") $farm=[Microsoft.SharePoint.Administration.SPFarm]::Local foreach ($feature in $farm.FeatureDefinitions)          {             if ($feature.Scope -eq "Farm" -and...

Thought of sharing my experience on an issue which took an entire day to resolve! Here it goes, Users unable to access the SharePoint site! Page keeps prompting for credentials thrice and returns a blank page. BUT site collection admin as well as farm account were able to access without any issue. Troubleshooting steps: 1. Checked for the event logs - Found nothing related 2. Restarted the security token service app pool. 3. Restarted IIS. 4. Cleared space in the drives. Nothing worked! 5. Performed Server reboot!  (1.App Server, 2.WFE, 3. DB Server) 6. Checked for the logs in all the servers. Error log in WFE server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specif...

Issue:  Unable to upload files to SharePoint document library irrespective of the document size. Solution: When you delete items from a SharePoint site, they're sent to the site Recycle Bin. When you delete items from a site Recycle Bin, they're sent to the site collection Recycle Bin.  A SharePoint site collection administrator can view and restore deleted items from the site collection Recycle Bin to their original locations. If an item is deleted from the site collection Recycle Bin, or it exceeds the retention time, it is permanently deleted. 1. Click the gear icon and go to the "Site Settings" page. 2. Under the Site Collection Administration, click on "Recycle bin". 3. Delete the unwanted files.