×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

What did I do?

What did I do?

What did I do?

(OP)
I copied a small range of cells from someone else's spreadsheet to use as as starter for my own. Two of the cells were used for inputing values which I abandoned and tried to delete. However, when I click on either of these 2 cells or select these cells by moving the arrow keys, an empty drop-down selection box appears and opens. When I move to another cell, the box with the down arrow disappears.

I was able to move these cells. However, the only way that I could get rid of them was by cutting and pasting them into a blank worksheet and deleting that sheet. Any clues?

RE: What did I do?

It is never as easy as simply cut and paste or copy and paste as Excel tends to try and maintain a link back to the original workbook.
It need not be that the cells you copied had formulae in them but that they were the output from some other function.
In your case you may have wanted to copy the cell contents which, had they been simple directly entered numbers or text would have been fine but if they originally were input as a function of some other cell or drop down then the link will be maintained.
I have tried this many times and in the end decided that the simplest solution is often to start from scratch.

JMW
www.ViscoAnalyser.com
 

RE: What did I do?

Steve

Looks like you've also copied the formats from the other spreadsheet which includes cells with validation (dropdown selection box)

To clear, try selecting the offending cells then Data-Validation-Settings, Allow: Any Value,

or reassign the lookup list to your current workbook

cherrypicker

RE: What did I do?

You might also try Tools/Options/Calculations and deselect the "Save external Links" tick box.
 

JMW
www.ViscoAnalyser.com
 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources