irish_loco
New Member
- Joined
- Oct 14, 2005
- Messages
- 37
Hello All,
I wanted to see if somebody could answer a question.
I know I can create lists and syncronize them with Sharepoint, but was wondering if there was a way to use the direct list from Sharepoint in a formula in the same way you write a formula to an external spreadsheet like below?
=SUM('\\path\[speadsheet.xls] Sheet1'!$A$1:$A$100)
I wanted to see if somebody could answer a question.
I know I can create lists and syncronize them with Sharepoint, but was wondering if there was a way to use the direct list from Sharepoint in a formula in the same way you write a formula to an external spreadsheet like below?
=SUM('\\path\[speadsheet.xls] Sheet1'!$A$1:$A$100)