Possible to link Excel cells to text box in Word using Word's text formatting?

A

Arle

Hi everyone. Here is one of those "is this possible" type situations,
which if possible, would make my Augusts less stressful each year.

Each August I'm in charge of putting together our annual statistics
and producing maps of the state to show activity in each county.
Initially my maps were Word documents with individual text boxes for
each #. I still have that version saved, but recently I've converted
it to a pdf document to make changing the numbers a lot easier
(although not being able to add lines of text is a hindrance
sometimes).

What I'd love to be able to do is to link that Word document map to my
excel spreadsheets that contain the data (and are included as charts
in the annual report book) so that I don't need to manually update the
maps. I tried it once, but what I got was a tiny box that was
formatted as an Excel cell and I couldnt' change the font face or size
within word.

Does anyone have any suggestions? Thanks a lot!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top