SharePoint By Yagya Shree

Posts Tagged ‘Excel

SharePoint 2013: _vti_bin/listdata.svc

leave a comment »


ISSUE:

When trying to create a data source connection in excel 2010 to connect to SharePoint list, We are getting below error in Excel:

https://<site>/_vti_bin/listdata.svc

PowerPivot For Excel

Cannot connect to specified feed. Verify the connection and try again. Reason: The remote server returned an error: (401) Unauthorized.

listdata

When we tried the same wcf connect in Chrome, We got below message:

HTTP 500

The Webpage can not be displayed

 

RESOLUTION:

  • It was identified that in the one of the list had a column name with special character i.e.(# ; : ) 
  • We renamed the column name without any specific characters
  • Tried the WCF connect again and it worked.

 

Refer: https://blogs.technet.microsoft.com/victorbutuza/2014/06/30/why-would-listdata-svc-return-an-error/

Written by Yagyashree

September 15, 2016 at 9:54 pm

Posted in sharepoint

Tagged with , , , , ,

SharePoint: Unable to start “Excel Calculation Services”

leave a comment »


ISSUE:
=======

–When trying to start “Excel Calculation Services” under central administraion–Services on Server, getting error message

“Unknown Error”

Or

“Failed to resolve the site ID for ‘Office Server Web Services’.”

–When we check the Event Viewer–Application Logs, getting following event ID 7034
 Log Name:      Application
Source:        Windows SharePoint Services 3
Date:          7/30/2009 9:04:35 AM
Event ID:      7034
Task Category: Topology
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      <SharePoint Server Name>
Description:
An attempt to start/stop instance  of service Excel Calculation Services on server <SharePoint Server Name> did not succeed.  Re-run the action via UI or command line on the specified server. Additional information is below.

Cannot open database “SharedServices1_DB” requested by the login. The login failed.
Login failed for user ‘Domain Name\<SharePoint Server Name>$’.
Event Xml:
<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event“>
  <System>
    <Provider Name=”Windows SharePoint Services 3″ />
    <EventID Qualifiers=”0″>7034</EventID>
    <Level>2</Level>
    <Task>807</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime=”2009-07-30T16:04:35.000Z” />
    <EventRecordID>15441</EventRecordID>
    <Channel>Application</Channel>
    <Computer><SharePoint Server Name></Computer>
    <Security />
  </System>
  <EventData>
    <Data>
    </Data>
    <Data>Excel Calculation Services</Data>
    <Data><SharePoint Server Name></Data>
    <Data>Cannot open database “SharedServices1_DB” requested by the login. The login failed.
Login failed for user ‘Domain Name\<SharePoint Server Name>$’.</Data>
  </EventData>
</Event>
Resolution:
===========
1. Find the command prompt under the start menu, right click on it and choose ‘Run as Administrator’.

2. Change directories to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin.

3. Run the following command:

STSADM.EXE -o provisionservice -action start -servicetype “Microsoft.Office.Excel.Server.ExcelServerSharedWebService, Microsoft.Office.Excel.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c”

Written by Yagyashree

July 30, 2009 at 9:54 pm

Excel Word Applications Problems

leave a comment »


Error Message: – When we tried to open the word or excel document from the document Library, it opens in internet explorer instead of office application.
Normally, this problem persists only with few document Libraries and specific with word documents or Excel Documents.
We start troubleshooting in SharePoint and suggested customer that this problem lies with the document Library and Might be corrupt. We quickly create new document library and issue resolved.
But this problem does not have any relation with the SharePoint.
Resolution:-
1. Open My computer
2. Click on Tools
3. Folder Options
4. File Types
5. One window will open in which multiple files types with extensions are mentioned [Name of the window:- Registered File Types]
6. Select the file extension [e.g. .doc ,.xls,xlsx etc]
7. Click on Advanced
8. You will get three options as Confirm open after download, always shows extension, Browse in same window.
9. If browse in the same window is checked then unchecked that option
10. Save and Ok.

Written by Yagyashree

January 29, 2009 at 7:00 pm

Posted in Microsoft Office, sharepoint

Tagged with , , ,

%d bloggers like this: