Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

How to freeze first few rows in the Office spreadsheet webpart

  Asked By: Andrea    Date: Feb 28    Category: Sharepoint    Views: 2507

I am using the "Import Spreadsheet" in the Lists to import an excel
spreadsheet to the sharepoint site. When I modify the excel sheet
and do a refresh on the sharepoint list, the changes are not
reflected. The imported spreadsheet on the sharepoint always has the
same original data which was there when the excel was first imported.



3 Answers Found

Answer #1    Answered By: Esteban Frank     Answered On: Feb 28

Import simply does a one time creation of the list. If you want an
Excel sheet linked to the list  for making future updates, you'll need to
export a new spreadsheet  from the list and make your updates there.

Answer #2    Answered By: Jabari Burks     Answered On: Feb 28

Or, if you have Office 2003, you can use the Export and Link to Excel
option that's available from the Datasheet View of a list  (in a task
pane that is hidden by default on the right hand-side of the datasheet!)

Once a list is linked you can use the List/Synchronize option in Excel

Answer #3    Answered By: Heena Desai     Answered On: Feb 28

I have a very simple query let me know if you folks could help me..

I add a office  spreadsheet webpart  to my homepage of the sharepoint  site.
The spreadsheet  has contents through 100 + rows. No, I want to freeze the cells
till the first 5 rows  as when I scroll through the rows down the top 5 rows
[with titles/descriptions] should be visible.

Is this possible ?? I tried the tools available but doesnt help. Appreciate any