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!

*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.

Jobs

Cannot link to another sheet in workbook

Cannot link to another sheet in workbook

(OP)
Here is the situation:

I have an Excel workbook with many worksheets, which I have developed over the years. I copied the attached Excel file "Beamanalysis" (which was written by Alex Tomanovich and is available on the AISC website), to insert into my workbook.

I am attempting to link cells in "Beamanalysis" to various cells on various sheets of my workbook to eliminate redundant input and to improve functionality.

However, the cells don't seem to link - for example, if I write in: =BH!A207 (where BH is one my worksheets), nothing links, the cell keeps reading '=BH!A207 instead of whatever numerical value was in cell A207 of my worksheet BH.

Also note the ' that gets inserted to the left.

RE: Cannot link to another sheet in workbook

Is that cell formatted as text?

RE: Cannot link to another sheet in workbook

(OP)
Yes it was formatted as text - I changed the format to numerical, and now it works fine.

Thanks!!!

RE: Cannot link to another sheet in workbook

Good call davidbeach!

=====================================
(2B)+(2B)' ?

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


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close