Export from Sharepoint to Excel

[tzrider]

please to be giving me the exact instructions to perform such jiggerypokery

To create the Excel table in the first place, go to the SharePoint list, click the actions menu, and choose "Export to Spreadsheet." You'll get a File Download dialog. Click the "Open" button.

Excel should open and the data should be displayed on a worksheet. Right-click anywhere in the set of data and on the resulting menu should be an option labelled "Table." Hover over it and a sub-menu will pop out. Choose the second option, "Convert to Range."

That's it.

 

[F4iChic]

To create the Excel table in the first place, go to the SharePoint list, click the actions menu, and choose "Export to Spreadsheet." You'll get a File Download dialog. Click the "Open" button.

Excel should open and the data should be displayed on a worksheet. Right-click anywhere in the set of data and on the resulting menu should be an option labelled "Table." Hover over it and a sub-menu will pop out. Choose the second option, "Convert to Range."

That's it.

woot arty

(I knew the first part, ovbiously, but thanks for the second part)