Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing old links
Hi,
Somewhere in my workbook are links to the files where I imported the data from. On occasion I've hit a control key combination by mistake that shows them. Can't recall what though. I didn't worry too much about it as it wasn't a problem. But now I've given it to someone else, he gets a whole lot of errors e.g. 'E:\1975-6\Copy of 1976csv.mdb' s 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. Those files don't even exist anymore. They were deleted after the import into Excel. Can I clean all references out of the workbook somehow? Thanks - Kirk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing old links
Try Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm kirkm wrote: Hi, Somewhere in my workbook are links to the files where I imported the data from. On occasion I've hit a control key combination by mistake that shows them. Can't recall what though. I didn't worry too much about it as it wasn't a problem. But now I've given it to someone else, he gets a whole lot of errors e.g. 'E:\1975-6\Copy of 1976csv.mdb' s 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. Those files don't even exist anymore. They were deleted after the import into Excel. Can I clean all references out of the workbook somehow? Thanks - Kirk -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Links | Excel Worksheet Functions | |||
Locating Links and Removing | Links and Linking in Excel | |||
Removing Links | Excel Programming | |||
Removing links | Excel Worksheet Functions | |||
Removing links | Excel Programming |