Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 28th 05, 11:23 PM
Leslie
 
Posts: n/a
Default Links between workbooks and emailing workbook

I have 2 workbooks in which one is the main workbook and the 2nd is a subset.
I used the =sumproduct and Match functions to do my links. When I emailed
the subset or 2nd workbook the person can't read it because they don't have
the main workbook. Any ideas how when the document transmit by email I can
get it changed into real values versus links.

  #2   Report Post  
Old June 29th 05, 07:14 AM
LenB
 
Posts: n/a
Default

Try copy, then paste special -- values to replace formulas with their
results.

Len

Leslie wrote:
I have 2 workbooks in which one is the main workbook and the 2nd is a subset.
I used the =sumproduct and Match functions to do my links. When I emailed
the subset or 2nd workbook the person can't read it because they don't have
the main workbook. Any ideas how when the document transmit by email I can
get it changed into real values versus links.

  #3   Report Post  
Old June 29th 05, 02:16 PM
Leslie
 
Posts: n/a
Default

I was hoping to figure out an automated way. If "they" don't have the main
workbook I would like to program something that says show or permit values
(not formulas) and keep formatting and don't look for updates or show that
screen that asks them do they want to update.

"LenB" wrote:

Try copy, then paste special -- values to replace formulas with their
results.

Len

Leslie wrote:
I have 2 workbooks in which one is the main workbook and the 2nd is a subset.
I used the =sumproduct and Match functions to do my links. When I emailed
the subset or 2nd workbook the person can't read it because they don't have
the main workbook. Any ideas how when the document transmit by email I can
get it changed into real values versus links.


  #4   Report Post  
Old July 1st 05, 07:29 AM
LenB
 
Posts: n/a
Default

Maybe this is what you mean. For the people receiving the file, they
could uncheck the setting for "Ask to Update Automatic Links" on the
edit tab of Tools - Options. Of course that will affect all
spreadsheets they open, not just yours.
Maybe you didn't understand what I first suggested, so here is more
detail. Before you send the file, save a new copy (if you need to keep
your copy with the links). Select All (Ctrl+a), then Copy (Ctrl+c),
then paste special - values (Alt e s v). Takes less than 2 seconds.
There will now be no links (or formulas) in this copy of the file.
Formatting will stay the same. Send it and they will be happy! Good
luck. If you want to automate it, record a macro and assign to a
button. If you are into writing macros, I think links are in a
collection so a loop to go thru them all and replace each link with its
value could be done.

Len

Leslie wrote:
I was hoping to figure out an automated way. If "they" don't have the main
workbook I would like to program something that says show or permit values
(not formulas) and keep formatting and don't look for updates or show that
screen that asks them do they want to update.

  #5   Report Post  
Old July 1st 05, 02:02 PM
Jane
 
Posts: n/a
Default

Thanks very much for the information. I think I'll do that.

"LenB" wrote:

Maybe this is what you mean. For the people receiving the file, they
could uncheck the setting for "Ask to Update Automatic Links" on the
edit tab of Tools - Options. Of course that will affect all
spreadsheets they open, not just yours.
Maybe you didn't understand what I first suggested, so here is more
detail. Before you send the file, save a new copy (if you need to keep
your copy with the links). Select All (Ctrl+a), then Copy (Ctrl+c),
then paste special - values (Alt e s v). Takes less than 2 seconds.
There will now be no links (or formulas) in this copy of the file.
Formatting will stay the same. Send it and they will be happy! Good
luck. If you want to automate it, record a macro and assign to a
button. If you are into writing macros, I think links are in a
collection so a loop to go thru them all and replace each link with its
value could be done.

Len

Leslie wrote:
I was hoping to figure out an automated way. If "they" don't have the main
workbook I would like to program something that says show or permit values
(not formulas) and keep formatting and don't look for updates or show that
screen that asks them do they want to update.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017