A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Linked Charts in Word/Excel 2007



 
 
Thread Tools Display Modes
  #1  
Old March 30th, 2009, 12:19 AM posted to microsoft.public.excel.links
gb0dms
external usenet poster
 
Posts: 20
Default Linked Charts in Word/Excel 2007

I’d appreciate any thoughts on this one it’s driving me crazy
We have a Word document which has many excel charts that are linked to it
Both the Word and Excel document were build it in 2007, so both 2007 pure.
But now when we link in the charts they are acting up so we checked the links
and it says the “link type” is a Microsoft Office Excel 97-2003 Worksheet
We have made sure our word and excel save options are for 2007 and not auto
down saving
But it still seems to be when we link
Any thoughts because when it does that it makes our charts wacky since we
are in a .dotx with linked 2003 charts

  #2  
Old March 31st, 2009, 12:21 PM posted to microsoft.public.excel.links
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default Linked Charts in Word/Excel 2007

Hi gb0dms,

What is the file format of the Excel workbook? Does it have an xlsx extension?

Also, if you save the Word document in the 97-2003 format, and format one or more of the charts 'in-line with text', then press
Alt-F9, the linking field code will be displayed. For an Excel 2007 workbook, the filename in the LINK field should include the xlsx
extension.

--
Cheers
macropod
[MVP - Microsoft Word]


"gb0dms" wrote in message ...
I’d appreciate any thoughts on this one it’s driving me crazy
We have a Word document which has many excel charts that are linked to it
Both the Word and Excel document were build it in 2007, so both 2007 pure.
But now when we link in the charts they are acting up so we checked the links
and it says the “link type” is a Microsoft Office Excel 97-2003 Worksheet
We have made sure our word and excel save options are for 2007 and not auto
down saving
But it still seems to be when we link
Any thoughts because when it does that it makes our charts wacky since we
are in a .dotx with linked 2003 charts


  #3  
Old March 31st, 2009, 11:07 PM posted to microsoft.public.excel.links
gb0dms
external usenet poster
 
Posts: 20
Default Linked Charts in Word/Excel 2007

both the word and the excel are saved as 2007 docs (.xlsx and .dotx)
when we alt F9 it shows the link and the file extenstion is .xlsx
but when you go to manage your link
either by right clicking and clicking links
or by
Window|Prepare|Edit/Manage Links
it says again the
Source File: has .xlsx extension
Item in File: has a .xlsx extension
Link Type: Here is where it says Microsoft Office Excel 97-2003 Worksheet

"macropod" wrote:

Hi gb0dms,

What is the file format of the Excel workbook? Does it have an xlsx extension?

Also, if you save the Word document in the 97-2003 format, and format one or more of the charts 'in-line with text', then press
Alt-F9, the linking field code will be displayed. For an Excel 2007 workbook, the filename in the LINK field should include the xlsx
extension.

--
Cheers
macropod
[MVP - Microsoft Word]


"gb0dms" wrote in message ...
I’d appreciate any thoughts on this one it’s driving me crazy
We have a Word document which has many excel charts that are linked to it
Both the Word and Excel document were build it in 2007, so both 2007 pure.
But now when we link in the charts they are acting up so we checked the links
and it says the “link type” is a Microsoft Office Excel 97-2003 Worksheet
We have made sure our word and excel save options are for 2007 and not auto
down saving
But it still seems to be when we link
Any thoughts because when it does that it makes our charts wacky since we
are in a .dotx with linked 2003 charts



  #4  
Old April 1st, 2009, 05:54 AM posted to microsoft.public.excel.links
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default Linked Charts in Word/Excel 2007

Hi gb0dms,

OK, In what sense are the charts 'acting up'/'wacky'? Those descriptions don't give anyone much to work with.

--
Cheers
macropod
[MVP - Microsoft Word]


"gb0dms" wrote in message ...
both the word and the excel are saved as 2007 docs (.xlsx and .dotx)
when we alt F9 it shows the link and the file extenstion is .xlsx
but when you go to manage your link
either by right clicking and clicking links
or by
Window|Prepare|Edit/Manage Links
it says again the
Source File: has .xlsx extension
Item in File: has a .xlsx extension
Link Type: Here is where it says Microsoft Office Excel 97-2003 Worksheet

"macropod" wrote:

Hi gb0dms,

What is the file format of the Excel workbook? Does it have an xlsx extension?

Also, if you save the Word document in the 97-2003 format, and format one or more of the charts 'in-line with text', then press
Alt-F9, the linking field code will be displayed. For an Excel 2007 workbook, the filename in the LINK field should include the
xlsx
extension.

--
Cheers
macropod
[MVP - Microsoft Word]


"gb0dms" wrote in message ...
I’d appreciate any thoughts on this one it’s driving me crazy
We have a Word document which has many excel charts that are linked to it
Both the Word and Excel document were build it in 2007, so both 2007 pure.
But now when we link in the charts they are acting up so we checked the links
and it says the “link type” is a Microsoft Office Excel 97-2003 Worksheet
We have made sure our word and excel save options are for 2007 and not auto
down saving
But it still seems to be when we link
Any thoughts because when it does that it makes our charts wacky since we
are in a .dotx with linked 2003 charts




  #5  
Old April 2nd, 2009, 03:25 AM posted to microsoft.public.excel.links
gb0dms
external usenet poster
 
Posts: 20
Default Linked Charts in Word/Excel 2007

It will either change them into pictures
or change them into objects
and when you right click on it and try to open
you get the error
"Object is Corupt or is no longer available"

"macropod" wrote:

Hi gb0dms,

OK, In what sense are the charts 'acting up'/'wacky'? Those descriptions don't give anyone much to work with.

--
Cheers
macropod
[MVP - Microsoft Word]


"gb0dms" wrote in message ...
both the word and the excel are saved as 2007 docs (.xlsx and .dotx)
when we alt F9 it shows the link and the file extenstion is .xlsx
but when you go to manage your link
either by right clicking and clicking links
or by
Window|Prepare|Edit/Manage Links
it says again the
Source File: has .xlsx extension
Item in File: has a .xlsx extension
Link Type: Here is where it says Microsoft Office Excel 97-2003 Worksheet

"macropod" wrote:

Hi gb0dms,

What is the file format of the Excel workbook? Does it have an xlsx extension?

Also, if you save the Word document in the 97-2003 format, and format one or more of the charts 'in-line with text', then press
Alt-F9, the linking field code will be displayed. For an Excel 2007 workbook, the filename in the LINK field should include the
xlsx
extension.

--
Cheers
macropod
[MVP - Microsoft Word]


"gb0dms" wrote in message ...
I’d appreciate any thoughts on this one it’s driving me crazy
We have a Word document which has many excel charts that are linked to it
Both the Word and Excel document were build it in 2007, so both 2007 pure.
But now when we link in the charts they are acting up so we checked the links
and it says the “link type” is a Microsoft Office Excel 97-2003 Worksheet
We have made sure our word and excel save options are for 2007 and not auto
down saving
But it still seems to be when we link
Any thoughts because when it does that it makes our charts wacky since we
are in a .dotx with linked 2003 charts





  #6  
Old April 2nd, 2009, 12:09 PM posted to microsoft.public.excel.links
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default Linked Charts in Word/Excel 2007

Hi gb0dms,

Have you installed the Office 2007 SP1 update? Have you tried repairing your Office installation (Word Options (or Excel
options)|Resources|Run MS Office Diagnostics)?

--
Cheers
macropod
[MVP - Microsoft Word]


"gb0dms" wrote in message ...
It will either change them into pictures
or change them into objects
and when you right click on it and try to open
you get the error
"Object is Corupt or is no longer available"

"macropod" wrote:

Hi gb0dms,

OK, In what sense are the charts 'acting up'/'wacky'? Those descriptions don't give anyone much to work with.

--
Cheers
macropod
[MVP - Microsoft Word]


"gb0dms" wrote in message ...
both the word and the excel are saved as 2007 docs (.xlsx and .dotx)
when we alt F9 it shows the link and the file extenstion is .xlsx
but when you go to manage your link
either by right clicking and clicking links
or by
Window|Prepare|Edit/Manage Links
it says again the
Source File: has .xlsx extension
Item in File: has a .xlsx extension
Link Type: Here is where it says Microsoft Office Excel 97-2003 Worksheet

"macropod" wrote:

Hi gb0dms,

What is the file format of the Excel workbook? Does it have an xlsx extension?

Also, if you save the Word document in the 97-2003 format, and format one or more of the charts 'in-line with text', then
press
Alt-F9, the linking field code will be displayed. For an Excel 2007 workbook, the filename in the LINK field should include
the
xlsx
extension.

--
Cheers
macropod
[MVP - Microsoft Word]


"gb0dms" wrote in message ...
I’d appreciate any thoughts on this one it’s driving me crazy
We have a Word document which has many excel charts that are linked to it
Both the Word and Excel document were build it in 2007, so both 2007 pure.
But now when we link in the charts they are acting up so we checked the links
and it says the “link type” is a Microsoft Office Excel 97-2003 Worksheet
We have made sure our word and excel save options are for 2007 and not auto
down saving
But it still seems to be when we link
Any thoughts because when it does that it makes our charts wacky since we
are in a .dotx with linked 2003 charts






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:03 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.