[Humphrey]

I have a report that links out to about 8 spreadsheets to provide updates on
all aspects of the project. Each month I want to generate a report showing a
static version of the charts as they are at the time.
Is it possible to update all linked components, and then do a save as,
removing the links and embedding the spreadsheet components into the newly
saved doc? This way the original is available for future upating and i have
a permanent record of where i was each month for the customer.

H

[Doug Robbins - Word MVP]

If you use Ctrl+A to select everything in the document and then use
Ctrl+Shift+F9, the fields in the document will be unlinked from their
source.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Humphrey" wrote in message
...
I have a report that links out to about 8 spreadsheets to provide updates
on
all aspects of the project. Each month I want to generate a report
showing a
static version of the charts as they are at the time.
Is it possible to update all linked components, and then do a save as,
removing the links and embedding the spreadsheet components into the newly
saved doc? This way the original is available for future upating and i
have
a permanent record of where i was each month for the customer.

H

[Graham Mayor]

Having pressed F9 after the CTRL+A to update the links

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Doug Robbins - Word MVP wrote:
If you use Ctrl+A to select everything in the document and then use
Ctrl+Shift+F9, the fields in the document will be unlinked from their
source.


"Humphrey" wrote in message
...
I have a report that links out to about 8 spreadsheets to provide
updates on
all aspects of the project. Each month I want to generate a report
showing a
static version of the charts as they are at the time.
Is it possible to update all linked components, and then do a save
as, removing the links and embedding the spreadsheet components into
the newly saved doc? This way the original is available for future
upating and i have
a permanent record of where i was each month for the customer.

H

[Humphrey]

Thanks to you both. That Ctrl Shift F9 seems like a dangerous tool to me. I
might keep that one to myself and not spread it around to the monkeys with
machine guns in the office.

[Suzanne S. Barnhill]

Very wise.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Humphrey" wrote in message
...
Thanks to you both. That Ctrl Shift F9 seems like a dangerous tool to me.
I
might keep that one to myself and not spread it around to the monkeys with
machine guns in the office.