Can we use Excel which is published to SP as a list?
Hi all,I am new to Excel used in SP and I have some dummy questions:1) Excel workbook is powerful for data calculation and I know we can publish an Excel file to the Portal. Can we just publish an Excel file and keep all the original calculations there and use them in the porta?2) Can I create a connectoin between a local Excel file and a published Excel table and synchronize something I write into the local workbook and refreshed in portal Excel?3) some links for Excel with SharePoint portal, for tutorials, blogs will be greately appreciated.Thanks in advance.allan
March 9th, 2010 11:39pm
Hi,
The following links are related How to work with Excel:
http://www.left-brain.com/tabId/65/itemId/1740/pageId/2/Beginning-Sharepoint-with-Excel-From-Novice-to-Pr.aspx
http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?List=56f96349%2D3bb6%2D4087%2D94f4%2D7f95ff4ca81f&ID=91
Work with Excel 2003:
http://office.microsoft.com/en-us/excel/HA010843681033.aspx
http://office.microsoft.com/en-us/excel/HP010317191033.aspx?pid=CH062528401033
Work with Excel 2007:
http://msdn.microsoft.com/en-us/library/bb462636(office.11).aspx
Hope this helps
Thanks!
Stanfford
Free Windows Admin Tool Kit Click here and download it now
March 11th, 2010 11:48am