I have a large MS Word document with about 200 links to various MS Excel files. All of the links were broken when we migrated to a new server. (I'll try to explain it in the last paragraph, but for the sake of time will skip it here))
I managed to restore all the TEXT links from Excel to Word, but I can't restore the links to tables and charts.
To restore the text links, from within Word, I selected Alt+F9, which allowed me to see all the TEXT links in the document. I then did a Find and Replace and updated the links to the proper location. But Alt+F9 doesn't show the links to the charts and tables.
Can I redirect/connect the links in a simple fashion?
Thanks in advance.
What happened --
How/why I don't know, but the end result was the links in Word were pointing to a folder that doesn't exist. For example, the orginal excel file was on the old server named Jerry, in .../reportpro/excel.xls The new server is named George and although the directory structure of the new server is the same, the links point to .../USER/reportpro/excel.xls
For whatever reason the "user" folder was inserted in the location. There is a USER folder, but the Excel files were never there and are not there. They are still in the original location
I have a client that has hundreds of spreadsheets that use database queries created within excel (not vb) to link to data stored in a third-party database (Pervasive) via ODBC.
Recently that datbase moved from Drive D: to Drive E:. I updated the ODBC connection to reflect the move. Unfortunately, now none of the excel queries work. I get an ODBC connection error.
If I create a brand new query using the same DSN, it works fine. The DSN also works fine in Access and Word.
I guess when the query is stored in Excel, it stores the the data location within the spreadsheet and no longer references the DSN. Is there any way to view or modify this connection short of creating new queries in hundreds of spreadsheets.
Thanks
I am consolidating servers and want to be able to identify any broken links
in Excel by searching for #REF! in the broken formula. Is there a way to
search for this in Excel files without purchasing third party software?
Hi there
I have word doc with aobut 40 or so excel graphs in it - which are linked to an excel file.
I get a message saying first:
"the document contains links that may refer to other files....."
click ok then
"Objects in this document contains links to files that cannot be found..."
because there are so many graphs - is there a quick and efficient way of finding out where the broken link is?
Hi,
I have a Powerpoint file that has a number of relatively complicated graphs in it, I need to update these graphs to include the data for November. But this Powerpoint was created by a colleague who has now left the company and had the linked Excel sheets stored on his PC.
The graphs are embedded Excel graphs, but when I right click to edit data, it says that the linked Excel files are unavailable. The data is obviously stored within the Powerpoint sheet though as the graphs display correctly and there is no way they could be accessing his now deactivated network share.
How can I extract the current data, allowing me to update the graphs?
Any help would be greatly appreciated.
Thanks
Hi,
I have a Powerpoint file that has a number of relatively complicated graphs in it, I need to update these graphs to include the data for November. But this Powerpoint was created by a colleague who has now left the company and had the linked Excel sheets stored on his PC.
The graphs are embedded Excel graphs, but when I right click to edit data, it says that the linked Excel files are unavailable. The data is obviously stored within the Powerpoint sheet though as the graphs display correctly and there is no way they could be accessing his now deactivated network share.
How can I extract the current data, allowing me to update the graphs?
Any help would be greatly appreciated.
Thanks
I'm working on an excel project that creates complexquotes from a master that has a series of combo boxes. The project works fine, but now I've been asked to add the ability to recall old quotes so that they can modified. I've purposely set up the code to break links when the quote pages are saved. Now I need to return these links and individual cell functions so that I can return value to my master. Anyone had a scenario like this. Can Excel act like an application and have the ability to open previous files and put all the setting back in tack or do I need to move this project to pure VB
Hi all,
I have a workbook(1) with lots of worksheets that pulls information from several other workbooks. Recently I updated the links and an error message appeared informing me that there were a few links that were no longer working...
I followed the message to edit links...
here I was able to see the file name of the link that was not working...
Is there something that can tell me where in Workbook(1) is the cell with the borken link... and where in the other work book it is pulling from?
Thanks for your help
JOE
I've got an excel file with LOTS of links... it's a sort of 'dashboard' that draws in data from all the individual data files in the company.
Recently, when I open the file it's telling me "this file contains one or more links that cannot be updates".
So... as I usually would, I use my 'find links' add in to find anything with a #REF in it... nothing.
Go into edit links and manually update each link... and they all update with no issue.
I just cannot find anything that's broken!!
What am I missing... where is this mysterious broken link?
