Can I link to a spreadsheet that lives on SharePoint using Excel 2007? I am
getting my reports to send their spreadsheets to SharePoint overwriting the
previous spreadsheet. I then import the relevant page into the master
spreadsheet I keep on my machine. This allows me to combine them all and do
the number crunching offline without the need to copy/paste from Outlook. It
also allows all staff to see the relevant data in one location.

I thought it was possible however when I try I get all the way through and
the last step give me a "Microsoft Office ACCESS database engine could not
find the object 'Tab Name'. Make sure the object exists and that you spell
its name and the path name correctly."

H