External Link Issue

I have come across something rather bizarre that I hope someone can
answer.

I opened a workbook in excel, we will call it Book1, that has external
links, I opt to "Don't Update". In the workbook are links to someone's
C: drive and as far as I am aware I don't have access to their drive.
Also FYI ... The status bar in the lower right says "Ready" ... not
"Calculate". Plus, if I hit "F9" the numbers remain the same.  When I
look at a cell "D10" it shows $90.

Then I open a copy of the same file but named Book2 .... Book1 is
still open. I again click "Don't Update" and the status bar says
"Ready". I click "F9" just to check that it is calculated. However, in
this book "D10" shows $100.

Now this is where it gets wierd. If I go back to Book1, cell "D10" now
says $100, it changed and so does Book2.

Why would this be happening? If I open the books reversed, Book2 and
Book1 the cells now both say $90. It seems that the last book to open
takes over.

Any ideas why this would happpen?

Thanks,
Paul
0
paulzumbo (1)
6/30/2009 9:07:13 PM
excel 39879 articles. 2 followers. Follow

0 Replies
542 Views

Similar Articles

[PageSpeed] 41

Reply:

Similar Artilces:

SelectSingleNode returns nothing. Namespace manager issue
I have the following code snipet: .... _xmldocManifest.Load(strManifestAbsolutePath) Dim manifestNSManager As XmlNamespaceManager = New XmlNamespaceManager(_xmldocManifest.NameTable) manifestNSManager.AddNamespace(String.Empty, "http://www.imsproject.org/xsd/imscp_rootv1p1p2") manifestNSManager.AddNamespace("ns", "http://www.imsproject.org/xsd/imscp_rootv1p1p2") manifestNSManager.AddNamespace("adlcp", "http://www.adlnet.org/xsd/adlcp_rootv1p2") manifestNSManager.AddNamespace("xsd", "http://www.w3.org/2001/XMLSchema") m...

Speed issues with large volume of serial numbers
Has anyone had issues auto assigning/posting a receipt with 100,000+ serial numbers in Dynamics GP? We were testing with the GP10 4/08 VPC (which I know isn't perfect), but it seems to take 15 or 20 minutes to assign. And 3rd party add-ons? hi Msauce What kind of Hardware are running this on? It sounds like the SQL server is having an issue and not he client. -- Fliehigh "MSauce" wrote: > Has anyone had issues auto assigning/posting a receipt with 100,000+ serial > numbers in Dynamics GP? We were testing with the GP10 4/08 VPC (which I know > isn't p...

external link values
Hi, is there a way to stop excel saving external link values when saving a document? i know i can copy then paste as values but the doc needs naming and saving at the outset. thanks Rick I don't know if this will do what you want, but you can use Tools; Options and uncheck the save external link values on the Calculation tab. >-----Original Message----- >Hi, >is there a way to stop excel saving external link values when saving a >document? > >i know i can copy then paste as values but the doc needs naming and saving >at the outset. > >thanks >Rick >...

RPC over HTTP connecting issue
I am having issues with users connecting to exchange 2007 (Via RPC over HTTP) with outlook 2003 using comcast. Works with verizon and at airports just does not work with comcast. Any suggestions would be helpful. I also use ISA2004 for Firewall. ...

W2K3 Site Links question
Hello, I am learning about AD sites and I am confused about how to link two sites together. As a practice I have created two sites, Columbus and KC, and when I created them I assigned them the DEFAULTIPSITELINK object. I have now created a second site link, called 'columbus-2-kc'. My question is: How do I link my two sites, Columbus and KC, to this new site link, columbus-2-kc? Do I just change the cost of the columbus-2-kc site link to a value lower than DEFAULTIPSITELINK? Or do I have to physically link the Columbus and KC sites to the new site link? Regar...

HTML link to a specifed worksheet
From an HTML page I would like to add a link to an EXCEL file but on a specific worksheet? I s this possible Thanks I think you just have to save the Excel file when you have active the worksheet that you want to show. I don't know of any other way. Regards, >-----Original Message----- >From an HTML page I would like to add a link to an EXCEL file but on a specific worksheet? I s this possible? > >Thanks >. > Hi try a link like the follwoing: path\filename.xls#Sheet3!A1 -- Regards Frank Kabel Frankfurt, Germany esoller wrote: > From an HTML page I would lik...

easily changing a linked reference
Hi I am building a report spreadsheet that links into and pulls information from another spreadsheet i.e LabourWk49.xls. I have quite a lot of links into LabourWk49.xls and wondered if there was an easy way of wholesale updating the weeks so the links can be changed to LabourWk50.xls. Is there a macro or something that could do this easily. I want people to be able to change the links easily. Much Appreciated Brian You could use: Edit|Links|Change source or if you're very careful, you could use: edit|replace Make sure you give it enough information so that just the file name will be ...

Access Data Base linked to Excel needs to be moved
I have an Excel workbook that is linked to an Access data base. User's enter data into Access and Managers use the Excel spreadsheet to filter the information. We need to move both the data base and the workbook to another location on our network, but it looks like the person that created all this stuff 3 years ago (and who is no longer with the company) hard coded the link between Access and Excel. Is there any way to change the path without re-creating everything? I can use either Excel/Access XP or 2003 Thanks in advance for any help Joseph K I think you'll need to pro...

[Excel] How do I change the default import external data settings.
I need to change the default settings for importing .csv files into Excel so that I don't have to change the settings every time I do the action. Is this possible? Many thanks to anyone who can help me!!! Maybe you could rename the .csv file to .txt and record a macro when you do it once. Then just rerun that macro the next time you need to import that file. (Keep recording while you add headers/footers/filters/etc and make it really useful.) djr wrote: > > I need to change the default settings for importing .csv files into Excel so > that I don't have to change the se...

Find formulas w links to other files and paste values #2
Hi, Just to let everyone know that I found the solution: http://www.cpearson.com/excel/xltools.ht -- bjar ----------------------------------------------------------------------- bjare's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1619 View this thread: http://www.excelforum.com/showthread.php?threadid=27617 ...

Linking Between Workbooks
Hi, Excel hasn't been preserving my linkage between workbooks. Any idea why this is the case? For example: I open a July Returns Analysis workbook and save it as August Returns Analysis. I then update all the workbooks that the August workbook will be linked to. I go to Edit, Links, Update Now for each link, then I save the file. Sometimes, after the workbook has been open for a while the numbers revert back to what they were before I went through the link update process (i.e. they revert back to July's numbers). I noticed that this occurs specifically when I open July&...

Delete Command Button Issue
Hello I am having a small issue with my delete command button. I have several valadation rules currently in my database. I also have a delete command button. The form has about 60 fields with lets say 15 required. If a user enters in 3 fields and then realizes they want to delete the record the delete button since the other valadation rules are seeing fields have not been filled out. Is there another command button i can put on the form to go along with delete? My button works fine on existing records. Any suggustions? Below is the code on the click: Private Sub DeleteRecord_Cl...

Finding the link from a commited PO item back to the SO
We are generating POs from SOP to handle some special order situations (so we force a backorder and generate the PO). And then things get really complicated with various thrid party add-ins and e-Connect. What it boils down to is that we need a way to identify the Sales Order that is linked to the item on the PO (from SQL Server, not from within GP). I know the information is actually at the item detail level or below, but we have no idea what tables to examine to discover the links that will lead us back to the original Sales Order number. Do any experts out there have a clue/hint/...

Style 304 (Change item price) worksheet issue from 1.3 refresh
Hi, We currently encountering issue on RMS 1.3 refresh. This issue is from issuing Style 304 (Change Item Price (regular)) worksheet on our client branches. When we try to issue this worksheet, it hangs all the HQ Manager application that are open everytime we approve this worksheet. Does anyone can't help us to troubleshoot this issue. We highly appreciated your reply. Thank you! Regards, Dexter This is a multi-part message in MIME format. ------=_NextPart_000_0190_01C6A1C2.DDA010E0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printa...

Linking to email...
I want to be able to automatically create an email with an attached text file. I don't necessarily want to link to Outlook, rather just whatever email software they use. I have tried a ShellExecute using "MailTO", but that won't allow an attachment, so I tried the following code, but simply nothing happens! The following code appears to run OK, all pointers look valid and the message box pops up at the end saying email sent, but nothing arrives. Here is the code I have tried: ======================= char* logPathName; logPathName = filePath.GetBuffer(0); MapiFileDesc attach...

Access 2003 ODBC linked to SQL 2005
Not sure if this is the right place to ask this question. I'm using SQL 2005 for data and connecting to the server using Access 2003. I have one table for stored images and the data field is set to Varbinary(max). I can link the table to Access, but when I try to open the table, Access shuts down without any error messages. If I change the Varbinary(Max) to Image data type, Access 2003 has no problems. My question is - is there a fix or a work around or is Access 2003 just too old for SQL 2005? And, Mike, is there some problem with converting the varbinary that you want to use to ...

External email address in Distribution list
Hi, Is it possible to add an external email address to a Global Distribution List? I have tried creating a "Contact" in the User list and adding that, but that gets returned. Thanks, John "John" <john_corangamite@hotmail.com> wrote in message news:ucj9MyCLGHA.1132@TK2MSFTNGP10.phx.gbl... > Hi, > > Is it possible to add an external email address to a Global Distribution > List? I have tried creating a "Contact" in the User list and adding that, > but that gets returned. > > Thanks, > > John The AD contact is the only (I...

Outlook "OFFLINE" issue..
Hi, Since we upgraded the Exchange 2003 to SP2, some of our users encountered an issue where their Outlook client 2003 were "Offline" by itself. The users need to manually uncheck the "Work Offline" to reconnect the server. Is there any issue with SP2 ? Thanks. Rgrds, Zul If there is an issue with an Exchange patch, it will most likely be = covered in an Exchange news group. Microsoft.public.exchange.admin is a good place to start your inquiry. --=81 Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail se...

vlookup issues
Excel 2003 My really be a "data" issues not a vlookup issue - but here is the problem; 1st column of my table_array: 149255 655122082938 655122082921 10655122525787 10655122525770 10655122082931 These will NOT sort in proper order. Does not matter if the cell is formatted text. Does not matter if the cell is formatted Number Does not matter if I clear all the data and type them in proper order by hand. why won't my data sort properly? Any help here will be appreciated. Thanks in advance dave Formatting text to numbers won't change anything, you need to force th...

External mail from the command line
HI all, I hope someone can help with my exchange 5.5 problem. In the environment we have 2 IMC servers which are both giving different results when sending mail via a command line to external recipients only, internal is fine. Both machines are windows 2000 with exchange 5.5ent both at the same patch and SP level (4) and have been configured the same and to forward mail to a host (our mail appliance). The one that is concerning me is the one that just returns the mail back to the sender stating that it cant find the recipient (external recipient). Now surely it should just be forwarding...

Linking workbooks #4
I've got a huge problem.... I've been working on a financial model for a month... basically a large budget in Excel... multiple files (150) with multiple sheets. All the files are placed in folders representing a hierarchy. I'm trying to "rollup" summarized statements that are consistent within all files to one Total file. My problem is that everything is carefully linked and now when I look at my linked cells, the data is there but when I F2 calc I get a #ref. The data looks o.k. but now I think I might have a problem. Does anyone know if there is a limit to th...

Verizon email issue
Running Exchange 2000 and not using a smarthost (our isp doesn't offer this). Mail server has a reverse DNS entry and have no problems emailing any other domain. The problem is that some of our users cannot email verizon.net addresses...bounces with a "550 You are not allowed to send mail" message. I submitted a Verizon whitelist form for our domain and recieved the response: After investigation, Verizon Online Security has determined that e-mail from your IP address will not be allowed access to the Verizon Online e-mail domain due to one or more of the below reasons: Yo...

outlook Over RPC STRANGE issue
I have an issue where OORPC seems to work for users who were already set up for OORPC yet new configurations of outlook do not work. I have verified that certificates etc are in place and working. It seems that outlook /rpcdiag is getting to 'directory - connecting' then closes after a few seconds with an 'exchange server is unavailable' type error message. I suspect this was introduced with the recent round of microsoft updates we went through with DST2007. Anyone having similar issues? Paul Can you check to see if these new accounts work from a machine from a use...

"links" tutorials
Dear All, It is very critical for my business to learn the basics and the backbone of links in Excel. Are there any tutorials or articles that gives wealth of information about MS Excel links? (in Excel 9.0.6) Web addresses are also welcome. You can also post to my e-mail above. Thank you in advance. Mustafa Hi Mustafa, You have additional answers in excel.links You have asked the same question several times in the Excel newsgroups. Basically you are not reaching more people but are asking the same people who may visit different newsgroups at different times. Please stick to o...

Outlook link opens browser, but page cannot be displayed.
Hi, When I click an url in Outlook, it opens IE fine. But it shows "The page cannot be displayed". More curious: if I have a working browserwindow open, and click the link, it works fine. This makes me think that I'm dealing with multiple instances of IE on my machine. Details: IE 6.0.2900.2180 Outlook 2003 11.5608.5606 Windows XP 2002 SP2 Thanks for your help! This problem has been hunting me for months. Paul ...