Archive

Archive for the ‘Excel’ Category

Powerpivot drillthrough limited to 1000 rows in Excel 2013

PowerPivot hide columns and unhide

Count Semicolon Values in Excel


Source: A;b;c;d

Open Excel

Paste in the Excel selected data.

Select Data which you have pasted

Click Data TabĂ Click Test to Columns

You will get new window.

Click Next

Uncheck TAB, check Semicolon

Semicolon will remove from your data.

Copy the data.

Select any cell

Right click

Click Paste Special

New window will open

Check Transpose

Your data will come vertical lines.

Now you count your values.

 

MOSS 2007-Excel


http://office.microsoft.com/en-us/sharepointserver/HA102078901033.aspx
http://www.codeguru.com/csharp/sample_chapter/article.php/c14305
http://blogs.msdn.com/performancepoint/
http://technet.microsoft.com/en-us/magazine/2009.02.bookbi.aspx?pr=blog
http://msdn.microsoft.com/en-us/library/aa973804.aspx
http://blah.winsmarts.com/2007-3-SharePoint_2007__Excel_Services_-_A_Quick_Introduction.aspx
http://www.codeproject.com/KB/sharepoint/DisplayingCharts.aspx
http://www.sharepointlabs.com/sharepoint-excel-service.htm
http://www.sharepointmonitor.com/2010/02/getting-started-with-the-sharepoint-2010-excel-services/
http://assets.devx.com/download/19873.pdf
http://sharepointsolutions.com/SharePoint-Training/Courses/Pages/MOSS-BDC-Enterprise-Integration.aspx
http://vivekthangaswamy.blogspot.com/2007/04/excel-services-in-moss-2007-sharing.html
http://office.microsoft.com/en-us/sharepointserver/ha101054761033.aspx
http://www.dynamicscare.com/blog/index.php/creating-a-dashboard-using-moss-excel-web-services-excel-2007-and-microsoft-crm/

http://msdn.microsoft.com/en-us/library/aa973804.aspx
http://msdn.microsoft.com/en-us/library/aa973805.aspx
http://blogs.msdn.com/excel/
http://blogs.msdn.com/cumgranosalis/

http://msdn.microsoft.com/en-us/library/ms546696.aspx
http://msdn.microsoft.com/en-us/library/cc514223.aspx#MOSS2007TenTips_MakinganExcelWorkbookCompatiblewithExcelServices
http://sharepoint.microsoft.com/blogs/mikeg/Lists/Posts/Post.aspx?List=1b3bbb8f%2D4b5a%2D4f72%2D94c4%2D94cb80bc3866&ID=1038

Enable Excel Services and data connections for a SharePoint team site

http://office.microsoft.com/en-us/sharepointserver/HA102078901033.aspx

Consuming Sharepoint Lists in Excel Services
http://blogs.msdn.com/luisbeonservices/archive/2006/09/28/consuming-sharepoint-lists-in-excel-services.aspx

http://office.microsoft.com/training/training.aspx?AssetID=RC102854661033&CTT=6&Origin=RP102854651033

\\192.168.1.173

BI

Excel with SQL server
http://www.ranson.us/Lists/Posts/Post.aspx?ID=4

moss videos
http://www.show-me-sharepoint.com/default.aspx

How do I… Edit SharePoint documents using Outlook 2007?
http://blogs.techrepublic.com.com/howdoi/?p=139

Documents Libraries / Report Libraries & Audience Targetting.
http://blogs.msdn.com/gunterstaes/archive/2007/01/18/moss-2007-documents-libraries-report-libraries-audience-targetting.aspx

Object model
http://blogs.msdn.com/cumgranosalis/archive/2006/03/24/ExcelServicesHelloWorld.aspx

Archiving with MOSS Records Center
http://zieglers.wordpress.com/2008/06/18/archiving-with-moss-records-center/

Read excel
http://geekswithblogs.net/AnneBougie/archive/2009/01/29/sharepoint-reading-an-excel-from-a-stream.aspx

Event Receiver :
http://www.simple-talk.com/dotnet/.net-framework/how-to-create-event-receivers-for-windows-sharepoint-services-3.0/
http://msdn.microsoft.com/en-us/library/bb736146.aspx
http://msdn.microsoft.com/en-us/library/dd239284.aspx
http://hristopavlov.wordpress.com/2009/02/24/understanding-sharepoint-event-receivers/
http://blah.winsmarts.com/2006-7-Sharepoint_2007__List_Events_Practical_Example__Creating_a_rigged_survey.aspx
http://developers.de/blogs/adis_jugo/archive/2009/03/12/develop-and-deploy-a-sharepoint-event-receiver-from-the-scratch.aspx

CREATING AND DEPLOYING FEATURE IN MOSS
http://farhanfaiz.wordpress.com/2008/01/24/creating-and-deploying-feature-in-moss/
http://www.codeproject.com/KB/sharepoint/ExtendingSPS.aspx

Integrating ASP.NET AJAX with SharePoint
http://sharepoint.microsoft.com/blogs/mike/Lists/Posts/Post.aspx?ID=3
http://www.slideshare.net/rob.windsor/integrating-aspnet-ajax-with-sharepoint-presentation
http://www.ajaxprojects.com/ajax/tutorialdetails.php?itemid=323
http://mctalex.blogspot.com/2009/06/integrating-ajax-control-toolkit-into.html

Customize the “NewForm.aspx” page for a SharePoint List

Sliver Light
http://www.hezser.de/blog/archive/tags/Silverlight/default.aspx

Read excel
http://www.eggheadcafe.com/community/aspnet/69/10072106/how-to-read-an-excel-file.aspx

How to: Locate and Copy Microsoft.Office.Excel.WebUI.dll
http://msdn.microsoft.com/en-us/library/aa549922.aspx

http://www.eggheadcafe.com/community/aspnet/69/10072106/how-to-read-an-excel-file.aspx

workflow
http://office.microsoft.com/en-us/sharepointdesigner/HA101829081033.aspx

MOSS VPC
http://www.pptspaces.com/sharepointreporterblog/Lists/Posts/Post.aspx?ID=17

Excel
http://www.trivadis.com/uploads/tx_cabagdownloadarea/ExcelAndExcelServices.pdf
http://www.ignify.com/PDFs/Ignify-Sharepoint-MOSS-Excel-Services.pdf

Open XML
http://msdn.microsoft.com/en-us/library/bb735939.aspx

web services
http://blogs.msdn.com/andreww/archive/2009/05/20/excel-services-getting-started-pt4-web-service-apis.aspx

http://vspug.com/tonstegeman/2007/03/13/using-analysis-services-data-in-excel-services-part-3-create-and-test-an-excel-sheet/

http://wssv3faq.mindsharp.com/default.aspx

Excel Services Workflows
http://technet.microsoft.com/en-us/library/cc440743.aspx

Excel Web Access
http://msdn.microsoft.com/en-us/library/bb758868.aspx
http://msdn.microsoft.com/en-us/library/cc268427.aspx
http://technet.microsoft.com/en-us/library/cc298845.aspx

PDF
http://assets.devx.com/download/19873.pdf
http://media.wiley.com/product_data/excerpt/99/04701048/0470104899.pdf

Blog
http://blogs.msdn.com/mikefitz/

Categories: Excel