Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheets referencing Obsolete Drive Mappings
How can I read all of my Office documents to check for links that use drive
mappings that are now obsolete? I would like to get a count. If I could do a substitute, that would be even better. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheets referencing Obsolete Drive Mappings
To get a count of the files, you can just use Window's search feature.
In XP - go to start -Search in the file name box type *.xls and then in the box where it says a "Word or phrase in a file" enter the drive path, e.g. C:\ This will show you all the files you need to modify. If there aren't many, just open each one up, go to Edit-Links and then update the reference to refer to the new drive. This will update all of the references in that workbook for you. On Oct 30, 6:40 pm, chessexpert wrote: How can I read all of my Office documents to check for links that use drive mappings that are now obsolete? I would like to get a count. If I could do a substitute, that would be even better. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cant save Excel spreadsheets to S drive | Excel Discussion (Misc queries) | |||
I can create new spreadsheets but old ones drive is unavailable | Excel Discussion (Misc queries) | |||
Copying Spreadsheets without referencing other workbook. | Excel Worksheet Functions | |||
Keyboard mappings | Excel Discussion (Misc queries) | |||
DELETE OBSOLETE INFORMATION FROM PIVOT TABLE | Excel Discussion (Misc queries) |