|
#name? errors on spreadsheet
I'm trying to create a spreadsheet to automatically track Word documents'
date. I'm copying the date from the title page and pasting into the Excel cell using Paste Special and creating a link to the text. It works when I set it up, but when I close the spreadsheet and then reopen it the linking process shows the #NAME? error. How can I correct this? -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence |
Hello, Providence. I go to Wilkes Barre. :)
Does the title have a bookmark name? It appears to work for me, and leaves this link: =Word.Document.8|'C:\Documents and Settings\Anne Troy\Desktop\Name of document.doc'!'!OLE_LINK1' Which is surrounded by curly brackets. What is the resulting link for you? ******************* ~Anne Troy www.OfficeArticles.com "John Gentile" wrote in message ... I'm trying to create a spreadsheet to automatically track Word documents' date. I'm copying the date from the title page and pasting into the Excel cell using Paste Special and creating a link to the text. It works when I set it up, but when I close the spreadsheet and then reopen it the linking process shows the #NAME? error. How can I correct this? -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence |
What version are you using? I tested in Excel 2003. And I do think pasting
your link here might be helpful--you know how picky 'puters can be about symbols and such... ******************* ~Anne Troy www.OfficeArticles.com "John Gentile" wrote in message ... Yes, I get a similar link, but the error only shows up after I choose to update the links when I open the spreadsheet. I need these links to show the dates the document was written and every time we change the date for a rewrite. -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence "Anne Troy" wrote: Hello, Providence. I go to Wilkes Barre. :) Does the title have a bookmark name? It appears to work for me, and leaves this link: =Word.Document.8|'C:\Documents and Settings\Anne Troy\Desktop\Name of document.doc'!'!OLE_LINK1' Which is surrounded by curly brackets. What is the resulting link for you? ******************* ~Anne Troy www.OfficeArticles.com "John Gentile" wrote in message ... I'm trying to create a spreadsheet to automatically track Word documents' date. I'm copying the date from the title page and pasting into the Excel cell using Paste Special and creating a link to the text. It works when I set it up, but when I close the spreadsheet and then reopen it the linking process shows the #NAME? error. How can I correct this? -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence |
Here is the link: =Word.Document.8|'\\VHAPROFPC1\LABORATORY\P&LM
POLICIES\General Lab\P&LMS POLICY 1 - SCHED CGS WKNDS, HOLID, VACA.DOC'!'!OLE_LINK25' I attempted to "bookmark" but it said that it could not parse the file. -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence "Anne Troy" wrote: What version are you using? I tested in Excel 2003. And I do think pasting your link here might be helpful--you know how picky 'puters can be about symbols and such... ******************* ~Anne Troy www.OfficeArticles.com "John Gentile" wrote in message ... Yes, I get a similar link, but the error only shows up after I choose to update the links when I open the spreadsheet. I need these links to show the dates the document was written and every time we change the date for a rewrite. -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence "Anne Troy" wrote: Hello, Providence. I go to Wilkes Barre. :) Does the title have a bookmark name? It appears to work for me, and leaves this link: =Word.Document.8|'C:\Documents and Settings\Anne Troy\Desktop\Name of document.doc'!'!OLE_LINK1' Which is surrounded by curly brackets. What is the resulting link for you? ******************* ~Anne Troy www.OfficeArticles.com "John Gentile" wrote in message ... I'm trying to create a spreadsheet to automatically track Word documents' date. I'm copying the date from the title page and pasting into the Excel cell using Paste Special and creating a link to the text. It works when I set it up, but when I close the spreadsheet and then reopen it the linking process shows the #NAME? error. How can I correct this? -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence |
I'm sorry, I forgot to mention that I am using Excel 2003 on a Win XP.
-- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence "Anne Troy" wrote: What version are you using? I tested in Excel 2003. And I do think pasting your link here might be helpful--you know how picky 'puters can be about symbols and such... ******************* ~Anne Troy www.OfficeArticles.com "John Gentile" wrote in message ... Yes, I get a similar link, but the error only shows up after I choose to update the links when I open the spreadsheet. I need these links to show the dates the document was written and every time we change the date for a rewrite. -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence "Anne Troy" wrote: Hello, Providence. I go to Wilkes Barre. :) Does the title have a bookmark name? It appears to work for me, and leaves this link: =Word.Document.8|'C:\Documents and Settings\Anne Troy\Desktop\Name of document.doc'!'!OLE_LINK1' Which is surrounded by curly brackets. What is the resulting link for you? ******************* ~Anne Troy www.OfficeArticles.com "John Gentile" wrote in message ... I'm trying to create a spreadsheet to automatically track Word documents' date. I'm copying the date from the title page and pasting into the Excel cell using Paste Special and creating a link to the text. It works when I set it up, but when I close the spreadsheet and then reopen it the linking process shows the #NAME? error. How can I correct this? -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence |
OK, I think I've got it working now. The trick is to save the linked document
after you make the link. Now when I close out the spreadsheet and then reopen it the update is accurate. -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence "John Gentile" wrote: I'm sorry, I forgot to mention that I am using Excel 2003 on a Win XP. -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence "Anne Troy" wrote: What version are you using? I tested in Excel 2003. And I do think pasting your link here might be helpful--you know how picky 'puters can be about symbols and such... ******************* ~Anne Troy www.OfficeArticles.com "John Gentile" wrote in message ... Yes, I get a similar link, but the error only shows up after I choose to update the links when I open the spreadsheet. I need these links to show the dates the document was written and every time we change the date for a rewrite. -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence "Anne Troy" wrote: Hello, Providence. I go to Wilkes Barre. :) Does the title have a bookmark name? It appears to work for me, and leaves this link: =Word.Document.8|'C:\Documents and Settings\Anne Troy\Desktop\Name of document.doc'!'!OLE_LINK1' Which is surrounded by curly brackets. What is the resulting link for you? ******************* ~Anne Troy www.OfficeArticles.com "John Gentile" wrote in message ... I'm trying to create a spreadsheet to automatically track Word documents' date. I'm copying the date from the title page and pasting into the Excel cell using Paste Special and creating a link to the text. It works when I set it up, but when I close the spreadsheet and then reopen it the linking process shows the #NAME? error. How can I correct this? -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence |
Cool. I couldn't figure it out!! :)
******************* ~Anne Troy www.OfficeArticles.com "John Gentile" wrote in message ... OK, I think I've got it working now. The trick is to save the linked document after you make the link. Now when I close out the spreadsheet and then reopen it the update is accurate. -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence "John Gentile" wrote: I'm sorry, I forgot to mention that I am using Excel 2003 on a Win XP. -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence "Anne Troy" wrote: What version are you using? I tested in Excel 2003. And I do think pasting your link here might be helpful--you know how picky 'puters can be about symbols and such... ******************* ~Anne Troy www.OfficeArticles.com "John Gentile" wrote in message ... Yes, I get a similar link, but the error only shows up after I choose to update the links when I open the spreadsheet. I need these links to show the dates the document was written and every time we change the date for a rewrite. -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence "Anne Troy" wrote: Hello, Providence. I go to Wilkes Barre. :) Does the title have a bookmark name? It appears to work for me, and leaves this link: =Word.Document.8|'C:\Documents and Settings\Anne Troy\Desktop\Name of document.doc'!'!OLE_LINK1' Which is surrounded by curly brackets. What is the resulting link for you? ******************* ~Anne Troy www.OfficeArticles.com "John Gentile" wrote in message ... I'm trying to create a spreadsheet to automatically track Word documents' date. I'm copying the date from the title page and pasting into the Excel cell using Paste Special and creating a link to the text. It works when I set it up, but when I close the spreadsheet and then reopen it the linking process shows the #NAME? error. How can I correct this? -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence |
well, thanks for your help. You did point me in the right direction.
-- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence "Anne Troy" wrote: Cool. I couldn't figure it out!! :) ******************* ~Anne Troy www.OfficeArticles.com "John Gentile" wrote in message ... OK, I think I've got it working now. The trick is to save the linked document after you make the link. Now when I close out the spreadsheet and then reopen it the update is accurate. -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence "John Gentile" wrote: I'm sorry, I forgot to mention that I am using Excel 2003 on a Win XP. -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence "Anne Troy" wrote: What version are you using? I tested in Excel 2003. And I do think pasting your link here might be helpful--you know how picky 'puters can be about symbols and such... ******************* ~Anne Troy www.OfficeArticles.com "John Gentile" wrote in message ... Yes, I get a similar link, but the error only shows up after I choose to update the links when I open the spreadsheet. I need these links to show the dates the document was written and every time we change the date for a rewrite. -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence "Anne Troy" wrote: Hello, Providence. I go to Wilkes Barre. :) Does the title have a bookmark name? It appears to work for me, and leaves this link: =Word.Document.8|'C:\Documents and Settings\Anne Troy\Desktop\Name of document.doc'!'!OLE_LINK1' Which is surrounded by curly brackets. What is the resulting link for you? ******************* ~Anne Troy www.OfficeArticles.com "John Gentile" wrote in message ... I'm trying to create a spreadsheet to automatically track Word documents' date. I'm copying the date from the title page and pasting into the Excel cell using Paste Special and creating a link to the text. It works when I set it up, but when I close the spreadsheet and then reopen it the linking process shows the #NAME? error. How can I correct this? -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence |
| All times are GMT +1. The time now is 02:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com