Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default linking worksheets


How can i link to an entire worksheet in another workbook, so that
changes may be made to the worksheet ragerdless of which workbook
containing the sheet is opened?
Thanks


--
bails
------------------------------------------------------------------------
bails's Profile: http://www.excelforum.com/member.php...o&userid=36159
View this thread: http://www.excelforum.com/showthread...hreadid=561142

  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,203
Default linking worksheets

If I understand what you're asking for, it can't be done.

You want Workbook1 to have a sheet in it named Sheet1
Then in Workbook2 you also want a sheet named Sheet1
(and actually the sheet names could be different)
And then if you make a change in Workbook1, Sheet1 you want those
changes to show up in Workbook2, on Sheet1

and at the same time you want it so that if you go the other way,
Make change in Workbook2, Sheet1 and have them
show up in Workbook1, Sheet1

You're trying to set up a closed loop. You can have one sheet in one book
echo the content of another sheet in another book, but you can't have 2
sheets in 2 books each trying to reference/change one another in mirror
fashion.

Besides if you do that, which one becomes the 'master' copy? Without one or
the other as being the source master, you'd quickly lose control of the whole
thing: you make a change in one workbook, I make a change in the other ...
who's change do you accept/use?

I can think of some exceptions to what I've said and even some work-arounds,
but a lot of that would depend on how you plan on using all of this. If you
are trying to have two (or more) people in separate locations be able to
update the information in one workbook, then you might look into sharing a
single workbook. Look under Help in Excel and search for
Share a Workbook
you'll find instructions for setting that up there.

"bails" wrote:


How can i link to an entire worksheet in another workbook, so that
changes may be made to the worksheet ragerdless of which workbook
containing the sheet is opened?
Thanks


--
bails
------------------------------------------------------------------------
bails's Profile: http://www.excelforum.com/member.php...o&userid=36159
View this thread: http://www.excelforum.com/showthread...hreadid=561142


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default linking worksheets


ok thanks for the info, i was hoping excel would have something similar
to Access where you can link to external table(s)


--
bails
------------------------------------------------------------------------
bails's Profile: http://www.excelforum.com/member.php...o&userid=36159
View this thread: http://www.excelforum.com/showthread...hreadid=561142

  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,203
Default linking worksheets

The problem with Excel is that linking is a one-way street, not a two way
street like it is with Access.

In an Excel cell you can basically either have a formula or a value. A
formula can be a link to someplace in another workbook (to get information
from there and display it in the cell of the book you are looking at). But
the moment you type something into that cell, you just erased the link and
replaced it with 'hard coded' something or other.

Also, closed workbooks aren't updated until they are opened. And for some
functions in a workbook to operate properly, both workbooks have to be open
at the same time. It's a mixed up world <g

"bails" wrote:


ok thanks for the info, i was hoping excel would have something similar
to Access where you can link to external table(s)


--
bails
------------------------------------------------------------------------
bails's Profile: http://www.excelforum.com/member.php...o&userid=36159
View this thread: http://www.excelforum.com/showthread...hreadid=561142


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
I am getting #VALUE! when linking worksheets - what am i doing wro KAT Excel Discussion (Misc queries) 7 February 23rd 06 07:46 AM
Linking Excel Worksheets GLT New Users to Excel 6 October 27th 05 03:57 PM
Linking between multiple worksheets, workbooks and columns cmvbfore Excel Discussion (Misc queries) 0 October 4th 05 06:58 PM
Linking Several Worksheets to One Worksheet TangentMemory Excel Discussion (Misc queries) 1 May 10th 05 11:37 PM
Linking across worksheets not working as desired Steve Excel Worksheet Functions 0 April 27th 05 10:30 AM


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

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

About Us

"It's about Microsoft Excel"