Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 23rd 04, 02:53 PM
Chaplain Doug
 
Posts: n/a
Default Linking to an Entire Sheet

Excel 2002-2003. How may I link an entire sheet in one workbook to a entire
sheet in another workbook. I know how to link cells. I know that I can have
each cell in one sheet link to the corresponding cell in another sheet. But,
I want to link sheet to sheet without having to do the individual cells.
Thanks.

  #2   Report Post  
Old December 23rd 04, 03:04 PM
Frank Kabel
 
Posts: n/a
Default

Hi
as answered previously: not possible. You have to put the formula in each
cell (you can just copy the first formula across)

--
Regards
Frank Kabel
Frankfurt, Germany

Chaplain Doug wrote:
Excel 2002-2003. How may I link an entire sheet in one workbook to a
entire sheet in another workbook. I know how to link cells. I know
that I can have each cell in one sheet link to the corresponding cell
in another sheet. But, I want to link sheet to sheet without having
to do the individual cells. Thanks.



  #3   Report Post  
Old December 24th 04, 07:39 AM
Mohan
 
Posts: n/a
Default

Hi
How about Selecting the whole sheet, copy and Paste Special and tick Links.
I think this should work This should Link to evey cell of the orignal sheet.

"Frank Kabel" wrote in message
...
Hi
as answered previously: not possible. You have to put the formula in each
cell (you can just copy the first formula across)

--
Regards
Frank Kabel
Frankfurt, Germany

Chaplain Doug wrote:
Excel 2002-2003. How may I link an entire sheet in one workbook to a
entire sheet in another workbook. I know how to link cells. I know
that I can have each cell in one sheet link to the corresponding cell
in another sheet. But, I want to link sheet to sheet without having
to do the individual cells. Thanks.







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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart Format & Linking? Ken Charts and Charting in Excel 2 January 22nd 05 02:32 PM
Do you have a work in progress sheet Admarkian Charts and Charting in Excel 0 January 6th 05 04:13 AM
how can i select all the cells with same color on a sheet if there are multipale colors by vba code uobt Charts and Charting in Excel 1 December 15th 04 05:27 PM
Hyperlink to specific sheet in Excel Web File jd17 Links and Linking in Excel 0 December 8th 04 09:03 PM
Can't save chart as object in current sheet Ann Scharpf Charts and Charting in Excel 1 December 3rd 04 11:24 PM


All times are GMT +1. The time now is 03:21 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