Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
JohnnyJomp
 
Posts: n/a
Default Links to other worksheets

Hi all...
I have a large worksheet and a smaller version of it. I have created columns
on worksheet 2 that are columns in worksheet 1.

When I change a cell in the orginal column, should not worksheet 2
automatically update?
It looks like I have to sort ws2 to get it to update.
I am doing anything wrong?
John
  #2   Report Post  
Bill Manville
 
Posts: n/a
Default

Not quite clear what the situation is.

You talk about 2 worksheets - in the same workbook?
Or do you mean 2 separate workbooks?

What is the formula in the cells containing the links?

What is your calculation mode (Tools / Options / Calculation) ?

Which version of Excel?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

  #3   Report Post  
JohnnyJomp
 
Posts: n/a
Default

Hi Bill:
Sorry for not being precise.
They are 2 wroksheets in 1 workbook. It actually isnt a formula, just a link
that I want to automatically update.

I also noticed that when I sort the columns, it will sort the ones that are
linked to empty cells first.
Actually, all I really need to do is write a little macro that will hide all
the columns that I don't need on the original worksheet. That is what I will
do; just should have done that to start!
Thanks for your attention, anyway...
John

"Bill Manville" wrote:

Not quite clear what the situation is.

You talk about 2 worksheets - in the same workbook?
Or do you mean 2 separate workbooks?

What is the formula in the cells containing the links?

What is your calculation mode (Tools / Options / Calculation) ?

Which version of Excel?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup


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
Cut links between worksheets in same workbook Houndstooth Excel Worksheet Functions 1 June 7th 05 11:36 AM
Want Excel to break links between worksheets in same file eclectic_kx Excel Worksheet Functions 1 May 25th 05 06:38 PM
can't update links...can't find links GJR3599 Excel Discussion (Misc queries) 1 April 4th 05 04:56 PM
Removing links to other worksheets from within a workbook rjb Excel Discussion (Misc queries) 2 December 9th 04 09:04 AM
print a list of worksheets and links Bottle Excel Worksheet Functions 1 December 8th 04 03:13 PM


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

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

About Us

"It's about Microsoft Excel"