Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 30th 04, 09:29 PM
kbigs
 
Posts: n/a
Default How do I unlink cells in different worksheets when there are no a.

I have a file with multiple worksheets. One column in two of the worksheets
are linked so that when a cell is cleared in one worksheet the same cell is
cleared in the other worksheet. There are no formulas in any of the cells.
How can I fix this?

  #2   Report Post  
Old December 1st 04, 02:22 AM
Dave Peterson
 
Posts: n/a
Default

It could be that the two worksheets are grouped together. Look for [Group] in
the title bar.

If you see it, rightclick on one of the grouped worksheets and select Ungroup
sheets.

====
But I bet it's a macro that's running when you make a change.

Rightclick on each of the worksheet tabs and select view code. (If the project
is locked, you'll need a password.)

Then look for some macro that's doing the work.

If I were you, I'd find the developer and tell him/her to turn it off.

Alternatively, you can stop macros (all macros!) from running via
tools|macro|security|security level tab.

Set it for High (or answer No when prompted if you set it medium).

But that might disable lots of stuff you need. You may not be happy with that
suggestion.

kbigs wrote:

I have a file with multiple worksheets. One column in two of the worksheets
are linked so that when a cell is cleared in one worksheet the same cell is
cleared in the other worksheet. There are no formulas in any of the cells.
How can I fix this?


--

Dave Peterson


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
Assigning Cells in worksheets to other data in other worksheets. David McRitchie Excel Discussion (Misc queries) 0 November 27th 04 06:15 PM
How do I retrieve data (specific cells) from multiple worksheets on a shared drive jbean Excel Worksheet Functions 1 November 10th 04 09:26 PM
sum of different cells in different worksheets??? lucylu Excel Worksheet Functions 1 November 10th 04 06:58 PM
Sum of cells in different worksheets HJK Excel Worksheet Functions 1 November 10th 04 07:38 AM
cells lose relativity to other WorkSheets after data sort? Ed Murray - ALPCO Excel Worksheet Functions 1 November 8th 04 07:02 PM


All times are GMT +1. The time now is 04:55 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017