PeterPivot
New Member
- Joined
- Jan 13, 2014
- Messages
- 10
Hi All,
I am trying to change the absolute file path for my connected workbooks to relative, but I'm coming across errors and I'm not too sure how to resolve.
My folder structure is as follows:
Client (folder)
-Master Report.xlsm (file)
--Data (folder)
---dataset1.xlsm (file)
---dataset2.xlsm (file)
I have copied this entire directory from my work computer to home, and I have tried going into the Data ribbon, followed by Connections > Properties > Definition and tried changing the path in the connection string (as it's still get the absolute path from my work network drive)
But I get the error "[Microsoft][ODBC Excel Driver] 'S:/(work drive location)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides"
Would you know how to fix this?
I am trying to change the absolute file path for my connected workbooks to relative, but I'm coming across errors and I'm not too sure how to resolve.
My folder structure is as follows:
Client (folder)
-Master Report.xlsm (file)
--Data (folder)
---dataset1.xlsm (file)
---dataset2.xlsm (file)
I have copied this entire directory from my work computer to home, and I have tried going into the Data ribbon, followed by Connections > Properties > Definition and tried changing the path in the connection string (as it's still get the absolute path from my work network drive)
But I get the error "[Microsoft][ODBC Excel Driver] 'S:/(work drive location)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides"
Would you know how to fix this?