Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link to spreadsheet on SharePoint
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link to spreadsheet on SharePoint
You can assign a mapped drive to the SharePoint folder and link to it use
that mapped drive letter. -- Gary''s Student - gsnu200753 "Humphrey" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link to spreadsheet on SharePoint
Thanks. I'm trying to avoid mapped drives since this will be accessed by
many people from both internal and external (outside the company) machines. I have just confirmed that this works in Excel 2003 using another computer so it's got me *&%&*% why it's stopped working in 2007. Further help would be appreciated. H |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SharePoint-Excel Link Create Double Lines When Updating | Excel Discussion (Misc queries) | |||
Copy/Paste into a spreadsheet that is posted to a Sharepoint site | Excel Discussion (Misc queries) | |||
Importing spreadsheet into sharepoint | Excel Discussion (Misc queries) | |||
#VALUE error when referencing spreadsheet on sharepoint library | Excel Worksheet Functions | |||
Why can't I maintain my link between Excel and SharePoint? | New Users to Excel |