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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics