Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
fixing links to external files if status shows OK
My workbook contains links to external xls files. When I open my workbook
and update links, I get message that some links cannot be updated. But when I open "Edit Links", all statuses are showing OK. How do I find which links cannot be updated? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
fixing links to external files if status shows OK
I have received the same message with the same information on mine. There
appear to be no missing updates. It could possibly be due to no changes on the linked files, thus no updates were available. I do agree that it is very confusing... "ccac user" wrote: My workbook contains links to external xls files. When I open my workbook and update links, I get message that some links cannot be updated. But when I open "Edit Links", all statuses are showing OK. How do I find which links cannot be updated? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
fixing links to external files if status shows OK
Sean, did you ever had "restored file" message after your file was corrupted
(mostly all the formating)? Some say it's because source file was saved in earlier version of Excel. I;m not sure, since I have all source files in Excel 2003. "Sean Timmons" wrote: I have received the same message with the same information on mine. There appear to be no missing updates. It could possibly be due to no changes on the linked files, thus no updates were available. I do agree that it is very confusing... "ccac user" wrote: My workbook contains links to external xls files. When I open my workbook and update links, I get message that some links cannot be updated. But when I open "Edit Links", all statuses are showing OK. How do I find which links cannot be updated? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
fixing links to external files if status shows OK
I get this error on a file with 2 links, all of which were created
approximately 3 months ago on the same version of Excel. I didn't lose any formatiing, and I don't get the message every time. So, earlier version is not an issue in my case, and does not appeat to be one in yours either. Best I can say is, if the links show OK, you should be a happy camper! "ccac user" wrote: Sean, did you ever had "restored file" message after your file was corrupted (mostly all the formating)? Some say it's because source file was saved in earlier version of Excel. I;m not sure, since I have all source files in Excel 2003. "Sean Timmons" wrote: I have received the same message with the same information on mine. There appear to be no missing updates. It could possibly be due to no changes on the linked files, thus no updates were available. I do agree that it is very confusing... "ccac user" wrote: My workbook contains links to external xls files. When I open my workbook and update links, I get message that some links cannot be updated. But when I open "Edit Links", all statuses are showing OK. How do I find which links cannot be updated? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
fixing links to external files if status shows OK
Right. Thank you.
"Sean Timmons" wrote: I get this error on a file with 2 links, all of which were created approximately 3 months ago on the same version of Excel. I didn't lose any formatiing, and I don't get the message every time. So, earlier version is not an issue in my case, and does not appeat to be one in yours either. Best I can say is, if the links show OK, you should be a happy camper! "ccac user" wrote: Sean, did you ever had "restored file" message after your file was corrupted (mostly all the formating)? Some say it's because source file was saved in earlier version of Excel. I;m not sure, since I have all source files in Excel 2003. "Sean Timmons" wrote: I have received the same message with the same information on mine. There appear to be no missing updates. It could possibly be due to no changes on the linked files, thus no updates were available. I do agree that it is very confusing... "ccac user" wrote: My workbook contains links to external xls files. When I open my workbook and update links, I get message that some links cannot be updated. But when I open "Edit Links", all statuses are showing OK. How do I find which links cannot be updated? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Says can't update links, but status ok | Excel Discussion (Misc queries) | |||
External Link Shows Formula Not Info | Excel Worksheet Functions | |||
Excel-links in worksheet shows #Ref | Excel Worksheet Functions | |||
Excel 2003: Temporarily "turning off" links to external files... | Excel Discussion (Misc queries) | |||
status bar shows "filter mode" | Excel Worksheet Functions |