MS Graph: Linked Data Overwrites Row and Column Headings
ID: Q112222
|
The information in this article applies to:
-
Microsoft Graph versions 5.0, 97 for Windows
SYMPTOMS
When you import data to a Microsoft Graph datasheet using the Paste Link
command, the row and column headings on the datasheet are overwritten.
WORKAROUNDS
To include row and column headings when you link data to a Microsoft Graph
datasheet, do the following:
- In the source application, include row and column headings when you
select the data to import. Copy the data you want to import.
- In the Microsoft Graph datasheet, choose Paste Link from the Edit menu.
- Click OK to overwrite the existing data.
- If you are using Graph 5.0, the ChartWizard--Step 1 of 1 dialog box
appears. (Assuming Data Series in Rows) If you are importing row
headings, under Use First Row For, select the Category (X) Axis Labels
option. If you are importing column headings, under Use First Column
For, select the Legend Text Option. Choose OK.
If you are using Graph 97, the ChartWizard does not run.
Note that when you use the Paste option to import data, the existing row
and column headings on the datasheet are not overwritten.
MORE INFORMATION
When you paste link data from a source application to a Microsoft Graph
datasheet, a dialog box appears with the message that the existing data
will be overwritten. This includes existing row and column headings on the
datasheet.
Any changes you make to the Microsoft Graph datasheet after you link data
are overwritten when you update the link. To make changes to the datasheet,
change the data in the source file.
REFERENCES
For more information about Importing Data, choose the Search button in
Microsoft Graph Help and type:
pasting data
Additional query words:
5.00 officeinterop 6.00 4.00 PowerPoint Office macppt winppt Winword Word Excel 8.00 ppt95 ppt97
Keywords :
Version : WINDOWS:5.0,97
Platform : WINDOWS
Issue type :