Excel Services cannot load the workbook that you requested.

When I am trying to Publish an excel to SharePoint using excel services I am getting the error message

File Not Found

Excel Services cannot load the workbook that you requested.

Usually if the file contains something that can't be published through excel services you would get a different error.

Generally the excel error messages highlights something so that we can take appropriate actions but the above message does not indicate anything. If you have a excel file which consist of 158 Tabs and the size present in MB's (Size of my excel file:11MB) so it is very difficult to find out which tab is causing the problem.

I did some testing and found out that this issue occurs because of large file size.

Troubleshooting carried out in the following manner:

Original File size: 11.0 MB         Result: Not Working

File Size: 8.92MB                        Result: Working

https://SharePoint2007/personal/amol/Shared%20Documents/Metrics%20Replica-8.92MB.xlsx 

File Size: 9.22MB                        Result: Working

https://SharePoint2007/personal/amol/Shared%20Documents/Metrics%20Replica-9.22MB.xlsx 

File Size: 9.45MB                        Result: Working

https://SharePoint2007/personal/amol/Shared%20Documents/Metrics%20Replica-9.45MB.xlsx 

File Size: 9.94 MB                       Result: Working

https://SharePoint2007/personal/amol/Shared%20Documents/Metrics%20Replica-9.94MB.xlsx 

File Size: 10.01MB                       Result: Not Working

https://SharePoint2007/personal/amol/Shared%20Documents/Metrics%20Replica-10.01MB.xlsx 

By default, Excel Services allows loading a file whose size <= 10MB on the server. 

When you add a QT with >= 3500 records, the file size grows > 10 MB and following alert appears: "Excel Services cannot load the workbook that you requested." when you try to load that on the server.

Resolution:

Go to Central Admin Page 

Select the SSP link/Shared Service Provider

Click on Trusted File Locations

Select the trusted location where your site is, and set Maximum Workbook Size = 100 MB (also set "session time out" and "Maximum request duration" = 3000 or more to make sure that server has enough time to process the workbook during load and before time outs).

If you have any queries/questions regarding the above mentioned information then please let me know...

I would be more than HAPPY 2 HELP U as well as RESOLVES UR ISSUES, Thanks

Data validation greyed out

We have received a strange ticket yesterday which is based on Data Validation. I have a spreadsheet that already has "drop down" arrows on every cell in a column data to select from. 

I was able to find the data that is supposed to be used for the "drop down" menu and that the data name range assigned to it.

The problem I'm having is that when I go to the menu bar and select Data, the Validation option is greyed out.

How can access the data validation menu when it is greyed out? The entire file is unprotected.

I have started my troubleshooting and firstly i saved the file to my desktop and checked the same option-still greyed out. So now one thing will be sure that the SharePoint is not in the picture. There is something is missing by means of Excel functionality or some options has been deactivated in that same excel spreadsheet.

Spend 40 mins to find out the root cause and resolution too :-)

Please refer the following options and your issue will be resolved:-

1.   Saved the Excel spreadsheet to your desktop.

2.   Open the spreadsheet

3.   Select Review (6th Tab from the left)-options are applicable for Office 2007.

4.   Click on Share Workbook

5.   Uncheck the option named as "Allow changes by more than one user at the same time. This also allows workbook merging"

6.   Click OK

7.   Saved the excel spreadsheet and check the results

8.   Upload to the SharePoint document library and check the results

You will find the option of "Data Validation" is now enable

Hey..Yippee--Expression from the user as his issue has been resolved.

If you have any queries/questions regarding the above mentioned information then please let me know...

I would be more than HAPPY to help you as well as RESOLVES your issues J J Thank you.

Working with Sharepoint list

Lists and libraries are stored in SharePoint Sites. A List can be thought of as a collection of pieces of information - all of which have the same properties.

This post will cover the following points:

1)   How to create a list

2)   How to add a column in a list

3)   How to change the name of the list

4)   How to enable folder option in list

5)   How to add a new content type to list

6)   How to transfer the list items from one list to another list

7)   How to set alerts on list

8)   How to set the versioning on the list

How to create a list

1. In the top link bar, click Create.
2. On the Create Page page, click Tasks.
3. In the Name box, type the name for the list as per the project requirements
4. In the Description box, type the description that relates to the project objectives
5. In the Navigation section, click Yes to put a link to this list on the Quick Launch bar on the home page. --Click Create

How to add a column in a list

1. Open the list in which you wants  to add a column
2. Click on Settings-->Select Create Column /Settings-->List Settings-->Under Columns-->Create      Columns
3. Type the name of the column as per the requirements
4. Select the type of information that this column will hold
5. Click OK

How to change the name of the list

1. Open the list for which you wants to change the name
2. Settings
3. List Settings
4. Under General Settings-->Title, description and navigation
5. Change the name of the list as per the requirement
6. Click on Save

How to enable folder option in list

1. Open the list on which you are working on.
2. Settings
3. List Settings
4. Under General Settings-->Advanced Settings
5. Please refer the Folder section-->Enable this option "Display "New Folder" command on the New menu?" to YES
6. Click Ok

How to add a new content type to list

1. Open the list on which you are working on.
2. Settings
3. List Settings
4. Under General Settings-->Advanced Settings
5. Please refer the content types section
Make this option ' Allow management of content types?' to YES
6. Click OK
7. Come back to the list settings page
8. Refer the section named as "Content Types"
9. Select "Add from existing site content types"
10. Select the appropriate content type from the available list and click on Add
11. Click OK

How to transfer the list items from one list to another list

lets take the example as List1 and List2

Datasheet View Option

1. Open the two list in two separate explorers
2. Change the view from the Standard view to Datasheet view for both lists
3. Let’s go to the tab in which list1 is currently open-->Copy the number of items that you wants to copy
4. Now let’s go to the second tab in which list2 is open-->Click on that specific cell from where you need to paste the data
5. Paste the data and that’s it-Data will be successfully copied without any issues.

List Template Option

1. Open the list that you want to transfer
2. Settings
3. List Settings
4. Under Permissions and Management-->Save list as Template
5. Give the name of the file as per the requirement, same name for the template too
6. Select the check box "Include Content"
7. Click Ok
8. The list will save to the list template gallery.

If you want that same list within the same site collection but to a different sub site then please follow the same procedure to create the list because you will find the same name that we have used to save the list as template which is a backup of the list that you wants to transfer.

How to set alerts on list

1. Open the list on which you are working on.
2. Actions
3. Select the option named as "Alert Me"
4. Select the number of alert notifications that you want
5. Click OK

How to set the versioning on the list

1. Open the list on which you are working on.
2. Settings
3. List Settings
4. Under General Settings-->Versioning settings
5. Refer the section named as "Item Version History"-->Select Yes
6. Click Ok

How to set unqiue permissions on list

1. Open the list on which you are working on.
2. Settings
3. List Settings
4. Under Permissions and Management-->Permissions for this list
5. Click on Actions-->Edit permissions
6. You will get the prompt that "You are about to create unique permissions"-->Click  OK
7. Now you have a filtering options for the list by which you can add/remove anybody from the list.

Please let me know in case of any queries/questions regarding the above mentioned information. I would be more than HAPPY to help you as well as RESOLVES your issue, Thanks..

Excel Cannot Connect to SharePoint List

As I am working in SharePoint support, I come across so many issues on day 2 day basis and always try to share with all of you as soon as the issue gets resolved.

Today, We have received one support ticket in which the user has created a list which consist of few items. When he selects list Actions--Export to spreadsheet--Excel opens up and Displays 'Security' dialog box by giving the option of 'ENABLE' and 'DISABLE'.

When user selects the Enable button then 'Import Data' dialog comes up, and then user clicks OK. As soon as the OK action performs then suddenly it throws an error message: Excel Cannot Connect to SharePoint List

Resolution: 
Generally we start our troubleshooting from the SharePoint side as what is wrong with my SharePoint site, Is there any problem in the SharePoint list,

Does the Office which is installed on the machine is causing the problem?

Is there any site collection feature turned off?

Is there any problem in the SP-Database?

Problem with the IIS?

so things are there by which we can think off but don't waste your time in doing all these things as I have done all these things and the resolution is quite simple which you can implement without any help.

1)   Open the Internet Explorer

2)   Tools

3)   Internet Options

4)   Advanced Settings

5)   Scroll downwards and reach towards the section named as "Security"

6)   CHECK FOR SERVER CERTIFICATE REVOCATION--which is by default checked

7)   Unchecked it

8)   Apply and Ok

9)   Close all the internet explorers (IE) and open your SharePoint site in a new IE i.e. Browser/Explorer

You should be able to export the spreadsheet without any problems/issues.

Please let me know in case of any further queries/questions.

I would be more than HAPPY to help you as well as RESOLVES your issues, Thank you. 

How can I change the name of an existing Document Library?

As i already published some useful content in my previous post that covers basics of document library:

http://sharepointknowledgebase.blogspot.com/2011/05/how-to-change-document-library-url-in.html

I remembered two things which i have not mentioned in the above post are:

1. How can I change the name of an existing Document Library?

2. How to Change the Logo on Your SharePoint Site?

So let’s start with the first one:

1. How can I change the name of an existing Document Library?

1)   From the Library, use Settings menu, then Document Library Settings

2)   From the General Settings section select Title, description and navigation.

3)   From this screen you can change the title of the library.

4)   Click the OK button-that’s it-Done

2. How to Change the Logo on Your SharePoint Site?

1)   Log in to your SharePoint Site

2)   On the right, click Site Actions >> Site Settings

3)   Under Look and Feel click Title, Description, and Icon

4)   Skip down to the Logo URL and Description section.

5)   In the URL field, enter the full URL for the logo image you want at the top of your SharePoint site.

6)   Click OK and You are done!!

Please let me know in case of any queries/questions regarding the above mentioned information. I would be more than HAPPY to resolve your issues, Thanks!!

Change the document library URL

Sometimes, an easy task takes some time to resolve and becomes a headache. The Document Library is the most usable part in SharePoint and serves as document repository. In this post, i am going to highlight basic points which are related to document library but effective ones.

This post will cover:

1. How do you change the address of a document library?

2. How to upload multiple documents into a document library?

3. How do I change the properties on a document or item in a list?

4. How do I setup alerts on a document?

5. How do I send a link to a document to others?

Let’s start one by one. One request to everybody-Please let me know in case of any questions/queries regarding the below mentioned steps

I would be more than happy to help you as well as resolves your issues :-)

1. How do you change the address of a document library?

-Open your site in SharePoint Designer.

-It will display all the doc libs in the Folder List view (quick launch)

-Right Click the doc lib for which you want to change the URL

- Rename the doc lib. thats it-Done

2. How to upload multiple documents into a document library?

Well for this-several options are available by which you can achive the results:

Windows Explorer Option

-Click on the View Drop down

-Click on Explorer View

Explorer View Option

-Click on Actions

-Click on Open with Windows Explorer

-You can now drop files in here or paste file

Upload Multiple Documents Page option

-Click on Add New Document link

-Click on Upload Multiple Files...

-Select the Files you wish to upload

3. How do I change the properties on a document or item in a list?

-Hover over the document you wish to edit the properties or metadata for

-Click on on the down arrow to pull the menu

-Click on Edit

-Change the properties on this page

4. How do I setup alerts on a document?

-Hover over the document you wish to set an alert on

-Click on on the down arrow to pull the menu

-Click on Alert Me

-Specify the Alert settings you wish

-Click on OK

5. How do I send a link to a document to others?

-Right click exactly on the document you wish to send a link to

-Click on Copy Shortcut

Getting User Profile Data into InfoPath

InfoPath is based on Extensible Markup Language (XML). When you design a form template, InfoPath creates an .xsn file, which is a cabinet (.cab) file that contains the files necessary for the form to function, such as XML Schema (XSD) and XSL Transformation (XSLT) files. When a user fills out a form in InfoPath, the data in that form is saved or submitted as industry-standard XML
                  MOSS has a great new feature that allows the publication of InfoPath forms to the server and thus enabling users that do not have InfoPath installed to fill in forms without having to distribute or purchase InfoPath for each client.


I needed to get the display name for the logged in user from active directory to populate a text box in an InfoPath form and went searching Google for an answer and finally I found some really complex resolutions that I didn't even want to attempt to deploy.


1. code approach
http://msdn.microsoft.com/en-us/library/bb952744(v=office.12).aspx


2.Without code approach
http://blogs.microsoft.co.il/blogs/itaysk/archive/2007/04/05/InfoPath-_2D00_-Get-the-current-user-without-writing-code.aspx
 I can suggest you to go for 'without code' approach as it is very properly defined and easy to implement as i had used it many times without any issues...
Please check and let me know in case of any questions/queries... 
I would be more than happy to resolves your issues regarding the same.... Thanks 

How to open a list in Edit Mode

To open a List in edit mode and add the new Web Parts you usually need a SharePoint Desinger. 


But there is a trick, how to open a List in Edit Mode and have the “Add Web parts” window is displayed. 


Everything you need to do is to add  "&ToolPaneView=2" parameter to the List URL.


By means of this, you have the ability to add web parts and edit a List’s Form pages in the browser. It will look like:


http://SharePoint2007/Lists/ListName/ListFormView.aspx?&toolpaneview=2


Where ListFormView.aspx is either AllItems.aspx, NewForm.aspx, DispForm.aspx, or EditForm.aspx using the default names.


There is no SharePoint Designer used and no customisations to the page that require unghosting from the site definition.
Note:
ToolPaneView=2 -Shows the "Add Web Parts" toolpane, allowing you to drag and drop web parts onto a "Web Part Page".
ToolPaneView=3 -Shows the "Search" toolpane, letting you search through the web part galleries before adding a web part to the page.


Some useful info regarding the same:
1. Add “?contents=1″ behind the URL and you can delete any webpart from your page.


2. Find List Guid or view Guid:
In the list view – right click and view source. Then search for “ctx.Listname”.
The Guid looks like this:
{DEF643C7-CF80-4DF8-866F-C16DC017DFC0}.


The view Guid is found by searching for “ctx.view” and looks similar to the list Guid above.


If you have any information that you find valuable regarding the same then please share it by means of comments so that it will be useful for everybody.

Your Feedbacks/Suggestions/Comments are very important for me...If you have any Doubts/Queries/Confusion then please let me know...
I would be more than HAPPY to help you as well as RESOLVES your issues, Thanks

Hardware and software requirements (SharePoint Foundation 2010)

This article lists the minimum hardware and software requirements to install and run Microsoft SharePoint Foundation 2010.

http://technet.microsoft.com/en-us/library/cc288751.aspx  

Hardware requirements—Database servers  
http://technet.microsoft.com/en-us/library/cc288751.aspx#section3 

Software requirements
http://technet.microsoft.com/en-us/library/cc288751.aspx#section4 

Hardware and software requirements (SharePoint Foundation 2010)
http://technet.microsoft.com/en-us/library/cc288751.aspx#section2

Capacity management and sizing for SharePoint Server 2010.
http://technet.microsoft.com/en-us/library/cc261700.aspx

URL path length restrictions (SharePoint Foundation 2010)
http://technet.microsoft.com/en-us/library/ff919562.aspx

Demos and training for Office SharePoint Server 2007

I love to learn by watching videos, seeing how someone else accomplishes a task so that I can replicate that in my own environment.

In this post, you’ll find a plenty of material including free online videos to help you learn how to developing using SharePoint.

If you have any information that you find valuable regarding the same then please share it by means of comments so that it will be useful for everybody.

Your Feedbacks/Suggestions/Comments are very important for me...If you have any Doubts/Queries/Confusion then please let me know...I would be more than HAPPY to help you as well as RESOLVE your issues, Thanks

Training videos for SharePoint Enterprise search

The presentations provide details about key enterprise search capabilities in Microsoft Office SharePoint Server 2007: http://blogs.msdn.com/b/dhirajm/archive/2010/05/31/training-videos-for-sharepoint-enterprise-search.aspx

 Here is another set of videos and training material for Office SharePoint Server 2007:
http://blogs.msdn.com/b/dhirajm/archive/2010/05/31/demos-and-training-for-office-sharepoint-server-2007.aspx

Video demos and training for Office SharePoint Server 2007

http://technet.microsoft.com/en-us/library/cc262880%28office.12%29.aspx 

A six-part series on getting the most out of SharePoint Designer 2007

http://office.microsoft.com/en-us/sharepoint-designer-help/demos-a-six-part-series-on-getting-the-most-out-of-sharepoint-designer-2007-HA010219984.aspx

Video demos and training for SharePoint Server 2010

http://technet.microsoft.com/en-us/library/cc262880.aspx 

http://sharepointforum.com/en-US/Wiki/Video%20demos%20and%20training%20for%20Office%20SharePoint%20Server%202007.aspx

SharePoint Guidance – November 2008

This guidance helps architects and developers design, build, test, deploy, and upgrade SharePoint intranet applications. A reference implementation demonstrates solutions to common architectural, development, and application lifecycle management challenges: http://www.microsoft.com/downloads/details.aspx?FamilyId=C3722DBA-6EE7-4E0E-82B5-FDAF3C5EC927&displaylang=en 

SharePoint Designer 2007 Visual How-Tos

http://msdn.microsoft.com/en-us/library/dd146863.aspx 

 WSS 3.0 Visual How-Tos – Developer

http://msdn.microsoft.com/en-us/library/bb892193.aspx 

SharePoint Server 2007 SDK Online

http://msdn.microsoft.com/en-us/library/bb851473.aspx 

Video Demos and Training for Office SharePoint Server 2007 – End User Contains links to many Microsoft Office SharePoint Server 2007 video demos that are intended for IT professionals.

http://technet.microsoft.com/en-us/library/cc262880.aspx

SharePoint Developer Center

Find information about planning, coding, building, deploying, and migrating solutions for Microsoft Office SharePoint Server 2007: http://msdn.microsoft.com/en-us/office/aa905503.aspx

Icons in Datasheet view for lists in SharePoint does not display correctly with office 2003

Office 2003 has so many limitations as compare to advanced version i.e. Office 2007. Microsoft recommended that if we want to use SharePoint 2007 in feasible manner then the best version is Office 2007.

I have two Virtual machines for testing from the client perspectives: One with Office 2003 and second with office 2007.

Issue is: When i tried to open a sharepoint list in datasheet view then the icons didn't render properly
Note: This is my Office 2003 with SP3 machine

Standard view is working correctly, problem is only with Datasheet view

Troubleshooting Did:
-Installed the windows sharepoint services support component by means of Office options
-checked the number of characters in the URL & that's fine (256 character limitation)
-checked with Office 2007, works perfectly

Now the questions arises: what is the problem with Office 2003. Not able to find out the root cause behind this but seems to be a Design Limitation with Office 2003.

Conclusion:
This issue is a design limitation for integration between Microsoft Office 2003 and SharePoint, and is only present for List's Datasheet view.
As a result, you cannot browse the folders from this view.

If you open a Document Library in Datasheet View, the Icons are rendered correctly.
If you open a List in Datasheet View with Microsoft Office 2007 the Icons are rendered correctly.

Upgrade to Office 2007 or later in order to avoid this behavior with SharePoint.


If you have any queries/questions regarding the above mentioned information then please let me know... I would be more than happy to help you as well as resolves your issues...