Simple linking cells issue

please help.  I'm linking cells in a worksheet and it works fine for me
However, after I send the file to a fellow employee,  it doesn't wor
for him.  He double clicks on the link and it just displays the cel
the link should go to.

For example if I'm linking to cell A2, when my coworker clicks on th
the linke it comes up =$A$2 instead of going to A2

--
Message posted from http://www.ExcelForum.com

0
8/18/2004 9:53:16 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
388 Views

Similar Articles

[PageSpeed] 17

Tell them to try turning off "edit directly in cell"

It can be found in:  Tools|options|edit tab


"lasvegas <" wrote:
> 
> please help.  I'm linking cells in a worksheet and it works fine for me.
> However, after I send the file to a fellow employee,  it doesn't work
> for him.  He double clicks on the link and it just displays the cell
> the link should go to.
> 
> For example if I'm linking to cell A2, when my coworker clicks on the
> the linke it comes up =$A$2 instead of going to A2.
> 
> ---
> Message posted from http://www.ExcelForum.com/

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
8/18/2004 10:31:25 PM
thank you!


---
Message posted from http://www.ExcelForum.com/

0
8/18/2004 11:12:16 PM
Reply:

Similar Artilces:

URGENT:Concatenating 1000 cells into 1
I need to concatenate a 1000 cells into a single cell. Could someon give me a macro to help me do that? Or if you have any ideas do let m know. Thank -- Message posted from http://www.ExcelForum.com Hi Sub test() Dim c As Range, s As String s = "" 'Amend range as appropriate For Each c In Range("A1:A1000") s = s & " " & c Next c s = Trim(s) Range("B1") = s End Sub -- XL2002 Regards William willwest22@yahoo.com "es9004 >" <<es9004.18brvb@excelforum-nospam.com> wrote in message news:es9004.18brvb@excelforum-nospa...

Simple graph
I have a chart with zip codes and a population rate. ZIP RATE 80001 2.34 80002 1.23 80003 1.23 I want to make a chart that has the rate on the x axis and the number of times that rate occurs on the y axis. | | | * | | * |_________________________________ | | 1.23 2.34 Thank you. I will assume the ZIP and RATE stuff is in A1:B200 (labels in row 1) Label in G1 to read RATE (but leave it empty for now), label in H2 to read COUNT Make a list of rates in G2:G20 (say) In H2 =COUNTIF($B$2:$B$200,G2) Copy down the row Select H1:G20 and make a...

Select Specific Data From Cells For A Chart
I have a spreadsheet that has a row that I want to use as a data range in a chart. The cells in the row contain three numbers on the left and three letters on the right. I can select just the three numbers by using “LEFT(A1:Z1,3)”. How do I use that formula to select just the three numbers for the data range in the chart? Note that your formula is incorrect in what you think it does, the LEFT function cannot reference a range of cells. To reference the first 3 cells in a row: =OFFSET(A1,,,,3) To reference cells C1:E1 would be: =OFFSET(A1,,2,,3) -- Best Regards, Luke...

Link and Embed in 2003
Using the Insert>Picture>From File comand we can use either the 'insert' or 'link to file' command to insert a picture. During our development we prefer to link pictures then when completed save the .ppt with all pictures embedded. 1. When pictures are in slides during design is it possible to tell if the picture is linked or embedded? 2. Is there a way to embed any/all linked pictures when the slide presentation is completed without going to each slide and reinserting the picture as 'insert' Cheers! -- Blumburg In article <07E6153F-5D...

Hard Return in Cell
Can you put a hard return in a cell. Probably basic, but can't figure it out. Hi Alt Enter -- HTH. Best wishes Harald Followup to newsgroup only please. "Monica" <mbristow@adtron.com> wrote in message news:2ab8501c3927c$17cd5b00$a601280a@phx.gbl... > Can you put a hard return in a cell. > Probably basic, but can't figure it out. Monica Yes: hold down the Alt key and press Enter. However, you might like to follow the exchange in the posts just below titled "Excel not filtering as expected" in case that turns out to have any implications for what y...

Info about static library and linking
Hi All, Could anybody point me to resources that describe exactly what happens when one makes a static library from a code -- parsing is done, compilation is done, then there must be some where the information about the function in the library is located, how it is organized etc. Similarly, what exactly happens when we link the static library to the code. I have been trying to use a static library for three days, I have been put off by the error "unresolved symbol" or "unresolved external identifier" etc and I cannnot understand what is going on. Regards, Nure <nu...

Relative addressing in external links
On a weekly basis the company at which I am on assignment downloads data from a huge database which they then cut and paste into various Excel reports. I want to replace this cut and paste process using external links from the reports to the downloaded data files (which are created by .csv to ..xls). Once this is set up, theoretically, I will be able to download a new set of data files and then when I open the Excel reports the cells in the reports will update automatically with no cutting and pasting between files. The only rub is that sometimes a row or column might be added within th...

DDE link error Excel freezes
Hi, I am using Excel 2003 and in one sheet I have a DDE link from anothe program. When I open the sheet I get a question wether I want to updat the fields or not. When I click YES the sheet normally opens and I ca view the data. But sometimes it seems like Excel freezes and I have t wait 3-5 minutes until it resumes. Anyone that has any idea why? The source program is always started first by the way. Kennet -- Message posted from http://www.ExcelForum.com ...

Rollup 1 issue
Since installing the RollUp1 for CRM 3.0, Laptop client users get errors like "Failed move data for entity 'Contact'" on synchronising (going Offline). I've looked at the KB and there's nothing listed there post-Rollup1. Any solutions out there? There is a client version of the roll-up Im sure you installed but have to check. "Matt" wrote: > Since installing the RollUp1 for CRM 3.0, Laptop client users get errors > like "Failed move data for entity 'Contact'" on synchronising (going > Offline). I've looked at the...

Simple Simple Simple
Just started Excel (again) and need to make an easy speadsheet fo calculating square inches. Column A: Height Column B: Legnth Column C: Total Tags per 16 x 24 Column D: Cost per tag Figures I know: each sheet cost me $9.98. each sheet is 16 x 24 inches What I want to do is enter the Height, enter the Length and have th total (sum) be entered into columns C and D. I can't believe I forgot how to enter formulas. Any help will b appreciated. Thank you, Crai -- Message posted from http://www.ExcelForum.com Hi Craig, One Way, might be better ways but this'll work: List the colou...

Simple help with implementing Outlook-like GUI
Hi All. I am an experienced unix programmer who sometimes has to do something in the windows world, and always has newbie-questions. Basically I want to write an application program that looks like outlook in that it has nice icons down the left hand side that choose the content of the main area in the right hand side. So I started the MFC App wizard, and got me a SDI program with a CLeftFrame (CTreeView) and a CMainFrame (CFrameWnd). Then I prepared the following snippet of code to draw the buttons: // Create a pushbutton CBitmapButton* pmyButton; pmyButton = new CB...

Excel-Sage link error
Hi, I'm trying to connect to our Sage data which is stored in a folder on the server mapped to my L: drive. In Excel, I go to Data > Get External Data > New Database Query... Choose Data Source dialog, pick SageLine50v8* and click OK. I enter manager and my password and then get the following error message: Cannot find all files in data path Driver's SQLSetConnectAttr failed The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 2.00 I am using Sage v8.00.0019 and Excel 2000. All help appreciated cheers Pete Franklin > In Excel, I go to Data > Get...

Can't open web links from recieved email
When I receive email containing web links, my cursor changes to the "hand w/finger". Up until recently, if I then "clicked" on that link, my "Micro Inter Explorer" would automatically open and take me to that website. Now, it has started to "lock up" the system. I then must, and I repeat must, "control, alt, delete" to bring up the "end program" box, but that completely shuts down my Outlook Express 6. Did I inadvertently change a setting? Is there a fix? Some incoming url's can be "copied" and "pasted to t...

Simple hack to get $500 to your home. 06-05-10
Simple hack to get $500 to your home at http://uknews.tk Due to high security risks,i have hidden the cheque link in an image. in that website on left side below search box, click on image and enter your name and address where you want to receive your cheque.please dont tell to anyone. ...

If cell is Bold then 1, if cell is Italics then 2?
I have a list of hundreds of cells, the cells are either Bold, Italics, or Regular. I want those cells that are bold to result in 1 in another column. those in italics to will result in 2. Am I able to write a "if" function that achieve this? If not, what should I do? Please kindly advise One way, assuming data is in col. A: 1. Press Ctrl+F3. 2. Define the name "istyle" (no quotes) and in the "Refers To:" box put: =IF(GET.CELL(20,!$A1),1,IF(GET.CELL(21,!$A1),2,"")) 3. In cell B1 put: =istyle 4. Copy the formula down. 5. If you'...

Calendar in Cell Validation
I want to implement a cell validation such that when the user attempts to input a date, a "list" box-like functionality pops up that has a calendar and the user may then choose the date by picking with the mouse How would I implement this? Thanks Jerry Try the following Web site. http://www.fontstuff.com/vba/vbatut07.htm This site's author covers this in a tutorial, but also provides downloads. Mark <jerry.ranch@pioneer.com> wrote in message news:2r9t51pjmumjk7rjpopo7fuamg81gqkljq@4ax.com... >I want to implement a cell validation such that when the user attempts &g...

Simple Query Wizard hangs
I am using Access 2003 When I initiate the "Simple Query Wizard", I am presented with the first screen - "What fields do you want in your query" When I click on the pulldown list to select a table, I get the following message: "The expression On Get Focus you entered as the event property setting produced the following error: the text you entered isn't an item in the list * the expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]. * There may have been an error evaluating the function, event, or macro&q...

email links not working
Hi All I have posted on the following forums; http://www.dslreports.com/forum/r20506459-Outlook-Outlook-2007-and-links-within-emails and wonder if someone can help with resolving this issue of email links in outlook 2007 been restricted. Thanks you coulda just posted the error message. See http://www.slipstick.com/problems/link_restrict.htm for solutions. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips by email: da...

Linking tables in publisher 2003
I want to use tales to organize a long list. It will span several pages. I'd like to link them. How can I continue the tables over several pages? 128 rows is maximum even in Publisher 2007. I suggest MS Word. "Bina" <Bina@discussions.microsoft.com> wrote in message news:D00C4B0F-23A5-432C-BC06-AE6F77A04606@microsoft.com... >I want to use tales to organize a long list. It will span several pages. >I'd > like to link them. How can I continue the tables over several pages? I second the suggestion... -- Mary Sauer MSFT MVP http://office.microsoft.com/ http...

Link failure
Thanks in advance. I would appreciate any help via email. HTTP links in incoming emails fail in both Outlook Express and Outlook but not in Eudora. The failures take the form of "infinite wait' eventually requiring Ctrl_Alt- Del to stop the application. Thanks again. Dave ...

I Need a Simple Sales Software
Hello, I am looking for software to keep track of my prospects, customers, and the notes of the sales process. I spend about one hour a day on sales and marketing, so I prefer a simple and inexpensive software. Maximizer, Outlook, Act, and Goldmine seem made for the full-time professional salesperson. Please let me know if what I am looking for exists. Best Regards, T.I. ...

Default browser is not launched from mail link? Vista/outlook 2007
Not sure if this is a Vista or Outlook 2007 Issue. Selecting a web page from a URL contaiend within an email launches IE7 rather than Firefox which I have selected as my default browser. This is correctly configured in the 'Default Programs' application? I am having the same issue. Have double checked Default Browser settings. Both Vista & Outlook 07 here too. "Darren Griffin - PocketGPSWorld.Com" wrote: > Not sure if this is a Vista or Outlook 2007 Issue. Selecting a web page > from a URL contaiend within an email launches IE7 rather than Firefox whic...

Make it more simple or intuitive to do simple things
I appreciate the fact that applications are becoming more versatile and able to do things that we hardly thought possible in the past but I feel that in this added complexity you are losing sight of the need to do simple things easily without resorting to trial and error or consulting "help" which often anyhow doesn't lead one straight to the solution! An example is how to produce a chart with a series of months i.e Jan Feb Mar etc appearing on the X axis. This is no doubt something that resulted naturally in the first versions of Excel charts or in a competitor's ea...

Project
I am needing to write a report to report on Project hours as well as non-project hours. I would like to link the PA30101 (timesheet detail) and the upr30300(transaction history) tables, but I cannot find a common field. Does anyone have any suggestions? Thanks, Unfortunately, there is not a link. A better way to handle non-project time is to create a project for tracking that time and run all time sheets through Project. But, I understand you may not be in a position to make that architectural change. -- Charles Allen, MVP "Puckett" wrote: > I am needing to write a re...

Simple public folder permission problem
I have a public task list folder. However even though I have given everyone "Author" priviledges and full control of the directory, users cannot update the tasks (although they can create new ones). The changes to tasks get reset to their original values. Where should I look to fix this problem? Brian How did you grant Author Access, via Outlook or ESM? What do you meanyou gave them full control of the directory? "Brian Taylor" <taylorb@newsgroups.nospam> wrote in message news:e2hwumGrEHA.1160@tk2msftngp13.phx.gbl... > I have a public task list folder. Ho...