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
paulzumbo
excel
39879 articles. 
2 followers.
0 Replies
497 Views
Similar Artilces:
Linking multpile tasks to the same date
I am attempting to link the same task (review meeting) in multiple sub tasks. Each of the sub tasks have the same sequence of events (they are tracking drawing develepment for an item). I would like to have the review meeting held on the same day for all of the sub tasks. If one of the subtasks is delayed, I'd like to see the meetings for all of the subtasks adjust to the flow of the subtask with the latest meeting date based on the task durations of the delaying subtask. It almost seems like you would need to create a circular link to get this to work, but that is not al...
links in cells break and revert to user profile location
Hoping someone with great wisom can help.... if a user creates links in a spreadsheet to cells in other spreadsheets... all ok so far! if he/she then opens the spreadsheet but the linked files are unavailable (lets say they are on a disconnected network drive), excel decides to break the links and revert them to point back at the user's profile area (C:\documents and settings\etc....)... this is only a problem if a daft user then saves the file. My question is - is there a way (reg key or similar) to turn off excel trying to fix links in this way? what I actually want is for Excel to ign...
How do I link an image to a cell?
I have a list of addresses in an excel sheet and want to print al addresses on separate cards. One of the colums contains several names: i.e Joe, Carol, Will I want for each row (= address) where the cell contains "Joe" tha excel prints joe.jpg (Joe's signature) on the card etc. How do I do this based on this excel-file? Can I do it using Excel? Or do I need Word? Or publisher or combination? I use Office 97 and publisher 97 but could make use of a newer versio (2002) if necessary. TIA! T ----------------------------------------------- ~~ Message posted from http://www.E...
Import of external data
I have done an export of info from the database system and it comes in an ASCII comma delimated text format. This file contains things such as names and addresses and a field called description which can contain quite alot of info per record. It has been exported with quotes around it so in theory it should all import into one cell. Instead it is splittting it into many different cells and is virtually unreadable. If I export the data without this description it will import no problem into Excel and everything will be in the correct place. It is only when I export the description with it ...
Linking Outlook fields from the "Contact Folder" to a custom form in Outlook...
Using Exchange Server 2003/Outlook 2003, we have created a custom Help Desk form in Outlook. We would like the ability to link specific fields from the Contacts Folder (Example B), in a drop-down list box if possible. We are far from knowing that something like this is even possible. Would appreciate *any* suggestions. Thank you. ...
FInding external link
When I open a spreadsheet, I get asked if I want to update external links. There shouldn't be external links in this spreadsheet, so I must have accidentally left in a formula which I need to change to a value. But I can't find the offending cell. How do I search for a formula with an external link in it? -- Thanks, Fred Hi Fred, Try Bill Manville's FindLinks addin which is freely downloadable at: http://www.oaltd.co.uk/MVP/Default.htm --- Regards, Norman "Fred Smith" <fredsmith99@yahoo.com> wrote in message news:up6TR3crFHA.2228@TK2MSFTNGP10....
Send to Command - weird issue when using with Mail.app
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi, Weird issue here, my signature has our company logo in it and that appears fine when creating a new message inside mail. When I use the Word/Excel command: File>Send To> Mail Recipient (as attachment) the new email window pops up with the signature intact, then when the attachment is placed in the message (which it does automatically) it strips the logo image from the signature, but leaves the rest of the text there. I have the latest updates from MS for Office installed as well. Any ideas? ...
Linking workbooks #3
I am using winxp pro and msoffice 2003 > > We have a workbook with 40 some worksheets in it, each worksheet being a > listing of products and cost levels for a particular vendor. This is our > 'master' workbook. > > Each customer has a workbook containing the worksheets of the vendors > they use. There are about 55 of these 'customer' workbooks. > > I want to link the 'customer' workbooks/worksheets to the 'master' so > when the prices are changed on the 'master', they will be reflected > throughout all of the workbook...
External HDD Icons change.
Running Windows XP Pro. I have two external hard drives, both partitioned. They have now changed the icon to a "folder" when before they had a similar icon as my internal hard drive & opened in the same way (double-click) Now I have to open them like folders ie: with Windows Explorer. All help appreciated re; returning them to original state. TIA. You can create custom icons for your external hard drives as I do, so that when youy plugged in the drive its icon will different from the rest (easy identification). To do this: -Create your own icon, http://www.rw-design...
VPN issues
Recently i have installed Windows Server 2008 on my server in my basement and deployed it as a file server and a VPN so ica naccess my Files remtely since im in the military and travel alot. Heres my issue: From home i can do the following: Access all shares through my networking VPN inside the network to the server VPN to the Routers IP (my server is set to have ports forwarded to allow for VPN) Stream Video Access files Remotely (IE outside my home network) I can setup the VPN so it shows that im connected and the ipconfig in command prompt shows the link is active, howev...
offline address book issue #2
Hi, I am receiving a error "the operation failed" when there is a send/receive at outlook. I have recevied some errors in the event viewer after enable the logging on Offline Address Book generator for System Attendant. Entry '***' has invalid or expired e-mail certificates. These certificates will not be included in the offline address list for '\Global Address List'. - *** Offline Address List OALGen will skip user entry '***' in address list '\Global Address List' because the legacyExchangeDN 'ADCSuppressReplication' is invalid. ...
Document Linking
Hi I am running Windows 2000 with Word 2000. I am trying to link a paragraph in one document to another document so that when I update the paragraph it automatically updates in the other document. I have tried copying then paste special then paste link (Formastted Tex RTF) then I save both documents. But it dose not seem to work, What am I doing wrong? Thanks Hi John, This should be pasted in the Word newsgroups, not Excel. Anyway, if you update the source document then save it, you can get the target document to update by selecting the linked field and pressing F9. Alternatively, i...
Linking fields within the same project
Playing around an entry table I realized that I can Paste-Link a value from a custom, calculated field, into a non-custom field, such as duration, and that the updates propagate reasonably quickly, without needing to save the file. That seems to circumvent the 'no calculations in non-custom fields' dogma. Has anybody used this to do calculations for non-custom fields? How reliable can this be? No. You still can't get a formula into the built-in field, but your way does it by the back door. Some fields are calculated by MSP only, not user input, so you can't do ...
Looking for Followup response re: linking Contact Info. into Accounts
Good Afternoon, I recevied a response from someone named Dodd on Wed. April 28th in the evening. The email stated that they would post a response with a possible 'work around' solution on Thurs. April 28th. I am still waiting for that response. Thank you in advance. Kristina ...
email merge gives lost h-links
Hi, We have an access db containing email addresses and a word letter containing instructions and hyperlinks. When we do an email merge, the hyperlinks become disabled in the resulting email. When we merge the letter as an attachment, the links are available using CTRL-click. Is there a setting in security on client or our part that causes this to happen? How can we send live links? Thanks. ...
cross linking excel files
ok, there is a nut that i cant break. I have 2-3 excel files that need to be linked. File M (master) contains multiple worksheets, of all sorts of data, its the master file for my files File L, is a lookup file im creating for better usage, its used for dumping data from msproject and reformat some stuff. It has only one sheet of relevance. File S, the summary file is the thing i need help with, it is linked to both files and is used to create monthly summarys. In that file i am using a lot SUMIF elements like: SUMIF ([file M]sheet1!A1:A30;B8;[file M]sheet1!D1:D30) Now the thing is: Th...
Select all entry data from two linked (with a relationship) Tables
Hi, I have two tables that are liked with a relationship: "Orders" and "Reports" with the OrderNumber column. Orders Table (PK -> OrderNumber): OrderNumber HoursForOrder 123456 47 876433 63 Reports Table (PK -> ID): ID OrderNumber HoursWorked 4 123456 5 5 123456 4 6 876433 17 Question: What would be the SQL SELECT command if I have the "ID" of a Report, and I would like to get the "HoursForOrder" at the same time with a single command? Since they are already linked I am wondering if should I really need to execute t...
Exchange 2003
I'm stumped and I only have 1/2 of the puzzle. Our organization is signing up to begin an epaystubs service for our employees. The company that provides this service has asked us for our exchange server IP, email address for the service account, and a username/ password for the account. I have setup a service email account for notifications with a username and password. I gave this information to the company that is providing the service. However, it will not work. They house the software on their server and use the email account and credentials that I set up for the service account ...
Is store procedure always fast than Access linked table via ODBC?
I was assigned to upgrade one program from Access(using ODBC to connect to SQL 2000) to ASP.NET(using store procedure in SQL 2000). Finally, I tested them and found that ASP.NET is slower than Access. The mojority job of program is select some data from SQL 2000 tables, modify and then insert into some tables. Is store procedure always fast than Access linked table via ODBC? -- Message posted via http://www.sqlmonster.com Stored procedures don’t add any overhead and they can save compile time. It's the code in the stored procedure and the underlying tables / indexes that ...
sync issues folder
hi, i am traing to remove from my outlook 2003 the sync issues folder. (i know it is on the server) how can i do that ? i used one time the cash mode but not any more. thankes hlitvak! Try OWA. If that doesn't work, you could try an Exchange 4.0 or 5.0 client, if you can find a copy. -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backups!" "hlitvak" <hlitvak@discussions.microsoft.com> wrote in message news:170B2EEB-6F6C-4469-9680-3142E0B1F6C3@microsoft.com... > hi, i am traing to remove from my outlook 2003 the sync issues folder. ...
How to code macro to import web link and avoid frame within HTML?
Does anyone have any suggestions on how to import web link into Excel and avoid frame on web page? When I browse following link, it look fine on IE, but when I insert this link into excel, it shows nothing, because of frame within HTML. http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search&lang=en&year=2010&month=2&day=3 Does anyone have any suggestions on how to solve it within Excel? Thanks in advance for any suggestions Eric ...
SBS 2003 STD SP2 Exchange not receiving external messages
I've read many posts oncerning this problem but have been unable to make it work for me. 1. I have a small business acct with AT&T with port 25 open; 2. I'm able to send/receive internally and send externally; 3. DNS is hosted at ZoneEdit with a MX record (mail.ghttech.com) and A record (mail.ghttech.com); I can telnet (ghttech.com 25) from an external source and get a valid response; 4. When I send a e-mail message to an internal address I do not get a NDR kicking back to troubleshoot; 5. I have 2 NiCS configured (internal Private IP), (External Plugged into Rou...
Link name of the sheet to a cell.
Hi all, I am trying to link the name of the sheet (in the tab at the bottom of the workbook) so it appears in a cell. Cheers =MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,256 -- Message posted from http://www.ExcelForum.com Hi Try one of the following formulas (note: the workbook has to be saved before it'll work) File path and file name: =CELL("filename",A1) File path only =LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1) File name only =MID(CELL("filename",A1),FIND("[",CEL...
Updating external references
Hello Guys! How would you solve the following problem: I have a few houndreds of .xls files on a certain computer in the net, many of them having links in formulas to external .xls files. They now all should move to a different folder. This means the links are not valid anymore. I have to find all .xls files and update the links. How could I do that? best regards, tequilajoe ...
Unable to install Exchange 2003 (5.5 migration, LDAP/DS issues)
ADVERTISEMENTHello, The overall goal is a NT 4.0 migration to 2003�along with the migration the Exchange 5.5 server to Exchange 2003. Since we can't do an in-place upgrade from Exchange 5.5 to 2003, we need to install Exchange 2003 on an interim (3rd) server�.then temporarily move all the mailboxes, public folders, DLs, etc�to that Exchange 2003 server. Following that, we'll rebuild the Exchange 5.5 server as a Windows 2003 server and install Exchange 2003 and then move all data back to it. The issue is that we are unable to install Exchange 2003 on the interim server. There is appar...
I am attempting to link the same task (review meeting) in multiple sub tasks. Each of the sub tasks have the same sequence of events (they are tracking drawing develepment for an item). I would like to have the review meeting held on the same day for all of the sub tasks. If one of the subtasks is delayed, I'd like to see the meetings for all of the subtasks adjust to the flow of the subtask with the latest meeting date based on the task durations of the delaying subtask. It almost seems like you would need to create a circular link to get this to work, but that is not al...
links in cells break and revert to user profile location
Hoping someone with great wisom can help.... if a user creates links in a spreadsheet to cells in other spreadsheets... all ok so far! if he/she then opens the spreadsheet but the linked files are unavailable (lets say they are on a disconnected network drive), excel decides to break the links and revert them to point back at the user's profile area (C:\documents and settings\etc....)... this is only a problem if a daft user then saves the file. My question is - is there a way (reg key or similar) to turn off excel trying to fix links in this way? what I actually want is for Excel to ign...
How do I link an image to a cell?
I have a list of addresses in an excel sheet and want to print al addresses on separate cards. One of the colums contains several names: i.e Joe, Carol, Will I want for each row (= address) where the cell contains "Joe" tha excel prints joe.jpg (Joe's signature) on the card etc. How do I do this based on this excel-file? Can I do it using Excel? Or do I need Word? Or publisher or combination? I use Office 97 and publisher 97 but could make use of a newer versio (2002) if necessary. TIA! T ----------------------------------------------- ~~ Message posted from http://www.E...
Import of external data
I have done an export of info from the database system and it comes in an ASCII comma delimated text format. This file contains things such as names and addresses and a field called description which can contain quite alot of info per record. It has been exported with quotes around it so in theory it should all import into one cell. Instead it is splittting it into many different cells and is virtually unreadable. If I export the data without this description it will import no problem into Excel and everything will be in the correct place. It is only when I export the description with it ...
Linking Outlook fields from the "Contact Folder" to a custom form in Outlook...
Using Exchange Server 2003/Outlook 2003, we have created a custom Help Desk form in Outlook. We would like the ability to link specific fields from the Contacts Folder (Example B), in a drop-down list box if possible. We are far from knowing that something like this is even possible. Would appreciate *any* suggestions. Thank you. ...
FInding external link
When I open a spreadsheet, I get asked if I want to update external links. There shouldn't be external links in this spreadsheet, so I must have accidentally left in a formula which I need to change to a value. But I can't find the offending cell. How do I search for a formula with an external link in it? -- Thanks, Fred Hi Fred, Try Bill Manville's FindLinks addin which is freely downloadable at: http://www.oaltd.co.uk/MVP/Default.htm --- Regards, Norman "Fred Smith" <fredsmith99@yahoo.com> wrote in message news:up6TR3crFHA.2228@TK2MSFTNGP10....
Send to Command - weird issue when using with Mail.app
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi, Weird issue here, my signature has our company logo in it and that appears fine when creating a new message inside mail. When I use the Word/Excel command: File>Send To> Mail Recipient (as attachment) the new email window pops up with the signature intact, then when the attachment is placed in the message (which it does automatically) it strips the logo image from the signature, but leaves the rest of the text there. I have the latest updates from MS for Office installed as well. Any ideas? ...
Linking workbooks #3
I am using winxp pro and msoffice 2003 > > We have a workbook with 40 some worksheets in it, each worksheet being a > listing of products and cost levels for a particular vendor. This is our > 'master' workbook. > > Each customer has a workbook containing the worksheets of the vendors > they use. There are about 55 of these 'customer' workbooks. > > I want to link the 'customer' workbooks/worksheets to the 'master' so > when the prices are changed on the 'master', they will be reflected > throughout all of the workbook...
External HDD Icons change.
Running Windows XP Pro. I have two external hard drives, both partitioned. They have now changed the icon to a "folder" when before they had a similar icon as my internal hard drive & opened in the same way (double-click) Now I have to open them like folders ie: with Windows Explorer. All help appreciated re; returning them to original state. TIA. You can create custom icons for your external hard drives as I do, so that when youy plugged in the drive its icon will different from the rest (easy identification). To do this: -Create your own icon, http://www.rw-design...
VPN issues
Recently i have installed Windows Server 2008 on my server in my basement and deployed it as a file server and a VPN so ica naccess my Files remtely since im in the military and travel alot. Heres my issue: From home i can do the following: Access all shares through my networking VPN inside the network to the server VPN to the Routers IP (my server is set to have ports forwarded to allow for VPN) Stream Video Access files Remotely (IE outside my home network) I can setup the VPN so it shows that im connected and the ipconfig in command prompt shows the link is active, howev...
offline address book issue #2
Hi, I am receiving a error "the operation failed" when there is a send/receive at outlook. I have recevied some errors in the event viewer after enable the logging on Offline Address Book generator for System Attendant. Entry '***' has invalid or expired e-mail certificates. These certificates will not be included in the offline address list for '\Global Address List'. - *** Offline Address List OALGen will skip user entry '***' in address list '\Global Address List' because the legacyExchangeDN 'ADCSuppressReplication' is invalid. ...
Document Linking
Hi I am running Windows 2000 with Word 2000. I am trying to link a paragraph in one document to another document so that when I update the paragraph it automatically updates in the other document. I have tried copying then paste special then paste link (Formastted Tex RTF) then I save both documents. But it dose not seem to work, What am I doing wrong? Thanks Hi John, This should be pasted in the Word newsgroups, not Excel. Anyway, if you update the source document then save it, you can get the target document to update by selecting the linked field and pressing F9. Alternatively, i...
Linking fields within the same project
Playing around an entry table I realized that I can Paste-Link a value from a custom, calculated field, into a non-custom field, such as duration, and that the updates propagate reasonably quickly, without needing to save the file. That seems to circumvent the 'no calculations in non-custom fields' dogma. Has anybody used this to do calculations for non-custom fields? How reliable can this be? No. You still can't get a formula into the built-in field, but your way does it by the back door. Some fields are calculated by MSP only, not user input, so you can't do ...
Looking for Followup response re: linking Contact Info. into Accounts
Good Afternoon, I recevied a response from someone named Dodd on Wed. April 28th in the evening. The email stated that they would post a response with a possible 'work around' solution on Thurs. April 28th. I am still waiting for that response. Thank you in advance. Kristina ...
email merge gives lost h-links
Hi, We have an access db containing email addresses and a word letter containing instructions and hyperlinks. When we do an email merge, the hyperlinks become disabled in the resulting email. When we merge the letter as an attachment, the links are available using CTRL-click. Is there a setting in security on client or our part that causes this to happen? How can we send live links? Thanks. ...
cross linking excel files
ok, there is a nut that i cant break. I have 2-3 excel files that need to be linked. File M (master) contains multiple worksheets, of all sorts of data, its the master file for my files File L, is a lookup file im creating for better usage, its used for dumping data from msproject and reformat some stuff. It has only one sheet of relevance. File S, the summary file is the thing i need help with, it is linked to both files and is used to create monthly summarys. In that file i am using a lot SUMIF elements like: SUMIF ([file M]sheet1!A1:A30;B8;[file M]sheet1!D1:D30) Now the thing is: Th...
Select all entry data from two linked (with a relationship) Tables
Hi, I have two tables that are liked with a relationship: "Orders" and "Reports" with the OrderNumber column. Orders Table (PK -> OrderNumber): OrderNumber HoursForOrder 123456 47 876433 63 Reports Table (PK -> ID): ID OrderNumber HoursWorked 4 123456 5 5 123456 4 6 876433 17 Question: What would be the SQL SELECT command if I have the "ID" of a Report, and I would like to get the "HoursForOrder" at the same time with a single command? Since they are already linked I am wondering if should I really need to execute t...
Exchange 2003
I'm stumped and I only have 1/2 of the puzzle. Our organization is signing up to begin an epaystubs service for our employees. The company that provides this service has asked us for our exchange server IP, email address for the service account, and a username/ password for the account. I have setup a service email account for notifications with a username and password. I gave this information to the company that is providing the service. However, it will not work. They house the software on their server and use the email account and credentials that I set up for the service account ...
Is store procedure always fast than Access linked table via ODBC?
I was assigned to upgrade one program from Access(using ODBC to connect to SQL 2000) to ASP.NET(using store procedure in SQL 2000). Finally, I tested them and found that ASP.NET is slower than Access. The mojority job of program is select some data from SQL 2000 tables, modify and then insert into some tables. Is store procedure always fast than Access linked table via ODBC? -- Message posted via http://www.sqlmonster.com Stored procedures don’t add any overhead and they can save compile time. It's the code in the stored procedure and the underlying tables / indexes that ...
sync issues folder
hi, i am traing to remove from my outlook 2003 the sync issues folder. (i know it is on the server) how can i do that ? i used one time the cash mode but not any more. thankes hlitvak! Try OWA. If that doesn't work, you could try an Exchange 4.0 or 5.0 client, if you can find a copy. -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backups!" "hlitvak" <hlitvak@discussions.microsoft.com> wrote in message news:170B2EEB-6F6C-4469-9680-3142E0B1F6C3@microsoft.com... > hi, i am traing to remove from my outlook 2003 the sync issues folder. ...
How to code macro to import web link and avoid frame within HTML?
Does anyone have any suggestions on how to import web link into Excel and avoid frame on web page? When I browse following link, it look fine on IE, but when I insert this link into excel, it shows nothing, because of frame within HTML. http://www.hkab.org.hk/DisplayInterestSettlementRatesAction.do?Submit=Search&lang=en&year=2010&month=2&day=3 Does anyone have any suggestions on how to solve it within Excel? Thanks in advance for any suggestions Eric ...
SBS 2003 STD SP2 Exchange not receiving external messages
I've read many posts oncerning this problem but have been unable to make it work for me. 1. I have a small business acct with AT&T with port 25 open; 2. I'm able to send/receive internally and send externally; 3. DNS is hosted at ZoneEdit with a MX record (mail.ghttech.com) and A record (mail.ghttech.com); I can telnet (ghttech.com 25) from an external source and get a valid response; 4. When I send a e-mail message to an internal address I do not get a NDR kicking back to troubleshoot; 5. I have 2 NiCS configured (internal Private IP), (External Plugged into Rou...
Link name of the sheet to a cell.
Hi all, I am trying to link the name of the sheet (in the tab at the bottom of the workbook) so it appears in a cell. Cheers =MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,256 -- Message posted from http://www.ExcelForum.com Hi Try one of the following formulas (note: the workbook has to be saved before it'll work) File path and file name: =CELL("filename",A1) File path only =LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1) File name only =MID(CELL("filename",A1),FIND("[",CEL...
Updating external references
Hello Guys! How would you solve the following problem: I have a few houndreds of .xls files on a certain computer in the net, many of them having links in formulas to external .xls files. They now all should move to a different folder. This means the links are not valid anymore. I have to find all .xls files and update the links. How could I do that? best regards, tequilajoe ...
Unable to install Exchange 2003 (5.5 migration, LDAP/DS issues)
ADVERTISEMENTHello, The overall goal is a NT 4.0 migration to 2003�along with the migration the Exchange 5.5 server to Exchange 2003. Since we can't do an in-place upgrade from Exchange 5.5 to 2003, we need to install Exchange 2003 on an interim (3rd) server�.then temporarily move all the mailboxes, public folders, DLs, etc�to that Exchange 2003 server. Following that, we'll rebuild the Exchange 5.5 server as a Windows 2003 server and install Exchange 2003 and then move all data back to it. The issue is that we are unable to install Exchange 2003 on the interim server. There is appar...