I have an embedded Excel 97 (SR2) spreadsheet in Word 97 (SR2). Can anyone please tell me how I can reference the cells in the embedded sheet so that I can extract the values and use them elsewhere in the word doc. Thanks in anticipation.
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Embedded Excel spreadsheet
Home » Forums » AskWoody support » Productivity software by function » MS Word and word processing help » Embedded Excel spreadsheet
- This topic has 7 replies, 4 voices, and was last updated 24 years, 3 months ago.
Viewing 1 reply threadAuthorReplies-
WSPhil Rabichow
AskWoody Lounger -
WSGazza
AskWoody Lounger -
Andrew Lockton
AskWoody_MVP -
WSPhil Rabichow
AskWoody Lounger -
WSGazza
AskWoody LoungerJanuary 30, 2001 at 8:36 am #512203Andrew/Phil,
Thanks for your posts Guys – the best that I’d got to was to make links to the cells in Excel inside a corresponding table in Word.
This does what I’m after – automatically updating the Word doc when Excel changes and I can bookmark the links in Word to make the values available elsewhere if I need to.
My only concern is that the links will take too long to update as I’ll need about 50 of them to get the complete set of data out of Excel. I guess I’ll just have to try it and see how it holds up.
-
WSPhil Rabichow
AskWoody Lounger
-
-
-
-
-
WSfburg
AskWoody LoungerFebruary 1, 2001 at 11:06 pm #512763Hi Gazza,
Here’s another way which may accomplish what you want.
What I would do first is create an area in Excel with all of your values in 1 place. Preferably a new sheet but it doesn’t have to be. The key is to have all the values you want in 1 place. This place can just refer to the key cells elsewhere in the workbook by just =location of item (the ordinary way).
Make sure you include a label for each item. So with, say 5 items (for brevity), you’d have across a row (or down a col):
item1 item2 item3 item4 item5
50 30 25 3 600
where the vals are derived by the assignment mentioned above.Name the above range something like Sending_values.
Now go into Word doc where the info needs to be retrieved.
Go to Tools | Mail Merge…
Under 1. Main Document, you want to Create something. I don’t think it would matter if you chose Form Letter or Catalog since there’s not much diff between the 2 but for this purpose, there would only be 1 record to be merged anyway (the 2nd row of the above excel range).
Under 2. Data Source Get data, choose Open Data Source and navigate to your excel workbook (remember to choose files of type Excel). When you get to it, you will be given a choice of Entire Spreadsheet or any named ranges such as Sending_values. Guess which ones to pick.
You will then be prompted to enter Mail merge fields but Word will have picked up your col headings in row 1 as merge fields. Stick those whereever you want, can even repeat a field more than once. Alternatively, as has been suggested by others (but I don’t think it matters), you can insert the merge field once, bookmark the value, and then x-ref the bookmark wherever else you need it.
Now you are ready to merge (step 3). Just merge to your document and you’re done.
The downside to this vs linking is that you have to remerge each time the spreadsheet changes. But you can skip merge steps 1 and 2 since they won’t change.
What this approach does is avoid having to bring in the excel values as a table. Even if you link to them via the approach others have suggested, I would still put them in 1 place in excel, and then paste special with a link. You can put the paste special in a page at the end of the doc so people may not see the pasted table (don’t print it or hide it). then just use bookmarks as before for cross-ref’g.
Hope this helps.
Fred
Viewing 1 reply thread -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Microsoft Edge Launching Automatically?
by
healeyinpa
4 minutes ago -
Google Chrome to block admin-level browser launches for better security
by
Alex5723
1 hour, 53 minutes ago -
iPhone SE2 Stolen Device Protection
by
Rick Corbett
2 hours, 36 minutes ago -
Some advice for managing my wireless internet gateway
by
LHiggins
59 minutes ago -
NO POWER IN KEYBOARD OR MOUSE
by
HE48AEEXX77WEN4Edbtm
3 hours, 31 minutes ago -
A CVE-MITRE-CISA-CNA Extravaganza
by
Nibbled To Death By Ducks
11 hours, 23 minutes ago -
Sometimes I wonder about these bots
by
Susan Bradley
7 hours, 40 minutes ago -
Does windows update component store “self heal”?
by
Mike Cross
1 day ago -
Windows 11 Insider Preview build 27858 released to Canary
by
joep517
1 day, 1 hour ago -
Pwn2Own Berlin 2025: Day One Results
by
Alex5723
1 day ago -
Windows 10 might repeatedly display the BitLocker recovery screen at startup
by
Susan Bradley
21 hours, 15 minutes ago -
Windows 11 Insider Preview Build 22631.5409 (23H2) released to Release Preview
by
joep517
1 day, 4 hours ago -
Windows 10 Build 19045.5912 (22H2) to Release Preview Channel
by
joep517
1 day, 4 hours ago -
Kevin Beaumont on Microsoft Recall
by
Susan Bradley
16 hours, 37 minutes ago -
The Surface Laptop Studio 2 is no longer being manufactured
by
Alex5723
1 day, 12 hours ago -
0Patch, where to begin
by
cassel23
1 day, 6 hours ago -
CFPB Quietly Kills Rule to Shield Americans From Data Brokers
by
Alex5723
2 days, 1 hour ago -
89 million Steam account details just got leaked,
by
Alex5723
1 day, 13 hours ago -
KB5058405: Linux – Windows dual boot SBAT bug, resolved with May 2025 update
by
Alex5723
2 days, 10 hours ago -
A Validation (were one needed) of Prudent Patching
by
Nibbled To Death By Ducks
2 days, 1 hour ago -
Master Patch Listing for May 13, 2025
by
Susan Bradley
1 day, 12 hours ago -
Installer program can’t read my registry
by
Peobody
5 hours, 16 minutes ago -
How to keep Outlook (new) in off position for Windows 11
by
EspressoWillie
1 day, 23 hours ago -
Intel : CVE-2024-45332, CVE-2024-43420, CVE-2025-20623
by
Alex5723
2 days, 6 hours ago -
False error message from eMClient
by
WSSebastian42
2 days, 21 hours ago -
Awoke to a rebooted Mac (crashed?)
by
rebop2020
3 days, 6 hours ago -
Office 2021 Perpetual for Mac
by
rebop2020
3 days, 7 hours ago -
AutoSave is for Microsoft, not for you
by
Will Fastie
5 hours, 21 minutes ago -
Difface : Reconstruction of 3D Human Facial Images from DNA Sequence
by
Alex5723
3 days, 11 hours ago -
Seven things we learned from WhatsApp vs. NSO Group spyware lawsuit
by
Alex5723
18 hours, 44 minutes ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.