08 July, 2011

This page is accessing information that is not under its control. This poses a security risk. Do you want to continue?

One of my user raised a issue with us that he is getting some pop-ups while accessing sharepoint sites. its actually a warning message in the internet explorer as mentioned below: "This page is accessing information that is not under its control. This poses a security risk. Do you want to continue?"

One thing will be sure that this is a machine specific issue and some settings will be wrong in the IE. its takes some time to replicate the same issue on my test machine and resolved it too. Please refer the following steps regarding the same:

Resolution:
1. Start Internet Explorer.
2. On the Tools menu, click Internet Options.
3. On the Security tab, click Internet, and then click Custom Level.
4. In the Security Settings list, change Access data sources across domains (under Miscellaneous) to Enable.
5. Click OK to close the Security Settings dialog box.
6. Click Yes when you receive the following message:
Are you sure you want to change the security settings for this zone?
7. Click OK to close the Internet Options dialog box.


If you have any queries/questions regarding the above mentioned information then please let me know.
I would be more than HAPPY 2 Help you as well as resolves your issues, Thanks

07 July, 2011

The file may not exist, may be in use, or the Web server is temporarily busy.

Yesterday, we received another ticket which is based on Office issue in collaboration with SharePoint.

Excel Version: Office 2003
SP Version: SharePoint 2007


Some users are receiving the following error message when they are trying to save and check-in a document
[File name and path] cannot be accessed. The file may not exist, may be in use, or the Web server is temporarily busy.


This is a very strange issue becuase it has multiple resolutions so its very difficult to conclude regarding the one perfect solution.

Some Observation:
This behavior occurs because only one user at a time can make changes to a document that is stored in a document library in SharePoint. A user must check out a document from the document library before that user can make changes tothat document. If a document is checked out by one user, other users have read-only access to that document. Other users cannot change thatdocument or see the changes that are made to the document until that document is checked in. After the document is checked in, another user can check out the document and make changes to it.

By design, This behavior occurs for documents that are stored in document libraries, including shared Excel 2003 workbooks and other document types that support an option where multiple users canmake changes to the document at the same time.

Resolution that i had applied for my ticket:
1. Start
2. Programs
3. Microsoft Office
4. Open any blank office excel 2003
5. Help
6. Expand the double arrow/options
7. Detect and Repair
8. Excel will run for few moments and repaired if corruptions are there
9.  Once it gets complete then please close the excel and open the sharepoint site in a new explorer


Some more resolutions that you may try:

Resolution#1:If its Office 2007 then please try this:
1. Start
2. Programs
3. Microsoft Office
4. Open any blank office word document
5. Office ribbon (on the top)
6. Word options
7. Resources
8. Run Microsoft Office Diagnostics


Resolution#2:A fix was release in September (August updates)http://support.microsoft.com/kb/956064
or cumulativehttp://support.microsoft.com/kb/957022

Resolution#3: It seems to 'always' happen when it is a document library that requires check out to edit. Try to uncheck this option and check the results

Resolution#4:
Check if the user has multiple domain accounts. If he is using one domain account for the machine/Desktop and second domain account for the sharepoint site then also you will face this problem. Make sure, the logged in domain account is already added on the sharepoint site.


Resolution#5:If somebody is using a inbuilt SQL version of SharePoint then make sure that you have enough storage available so that you can do the check outs and remaining procedures, Thanks

If you have any queries/questions regarding the above mentioned information then please let me know...
I would be more than HAPPY 2 HELP YOU as well as RESOLVES your ISSUES :-)

06 July, 2011

MVP Award Renewal for 2011-2012:SharePoint Server





Today I was honored for the second time with the Microsoft MVP award. It’s great to be recognized for my efforts in the SharePoint community over the past year.

Microsoft does the awards on a quarterly basis now to spread out the workload of reviewing people but the end of the year seems a good time to reflect on things especially since the award is given for the community work done in the "previous year.

Many thanks to my lead "Abhishek Kant" and everyone at the MVP Award program who keeps this all together and moving.
if your interested in learning more about the Microsoft MVP Program check out these official program links: Becoming an MVP

Thanks to everyone who – directly or indirectly – contributed to this renewal.
Thank you Microsoft, and thank you the Microsoft MVP program and foremost – thank you, the SharePoint community!

04 July, 2011

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

24 June, 2011

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.