http://help.lockergnome.com/office/Links-forum-33.html Latest 15 Messages on help.lockergnome.com http://help.lockergnome.com/office/Excel-07-breaking-links--ftopict1006095.html#3141674 If the links were originally to files in the same folder as the spreadsheet or possibly sub folders thereof then Excel will hold them as relative links by default So when the spreadsheet gets moved somewhere else the links will be interpreted as relative to that new folder and the files may well not reside there I recommend trying the following 2003 or earlier : File > Proper http://help.lockergnome.com/office/Master-Spreadsheet-Links-Excel-2003-Excel-2007-Sheets--ftopict1004358.html#3138890 Have you found the solution on how to make the links automatically update when you open excel 2003 files in excel 2007? I am having the same issues It only works if I have all the files open that are linked back to http://help.lockergnome.com/office/Excel-Linking--ftopict1012886.html#3138833 Links will always update when both source and destination files are open Some formulas are too difficult for Excel to update when the source file is closed but in such cases I would expect to see an error value when the destination workbook is recalculated If you would like to share more information on the links that are not working in 2007 it might reveal something Bill Man http://help.lockergnome.com/office/Excel-query-link-named-range--ftopict1009225.html#3128697 Hi I have book1 that has a query that brings down a list from access name= Project I need to use this list in a drop down box validation I also need to update the list periodically The problem is that my users are opening the spreadsheet as a template and may need updates while using it They do not have Access so they can t do the update So I wanted to create book http://help.lockergnome.com/office/Excel-Hyperlink-change-main-folder-addres--ftopict1008741.html#3126841 hai please help me i created important excel file more than 1000 Row have hyper link now some error automatically changed all hyperlinked address main foledr eg before server all scan abc S01 pdf now my computer c document excel all scan abc S01 pdf i want to change all to original folder how please help http://help.lockergnome.com/office/Auto-update-linked-Cell--ftopict1007513.html#3123634 Bingo This works EXCELLENT We are using Excel 2003 SP3 Thank you for your help Bill Manville wrote: > Your Excel formula link is not a remote reference but an external > link What happens on opening the workbook depends on the version of > Excel you are using please advise > > In Excel 2003 look for the Edit > Links > Startup Prompt setting > Change it i http://help.lockergnome.com/office/Automatically-updating-summary-sheet--ftopict1007287.html#3121840 Hi I m new here and I hope someone can help I have a large excel workbook with a number of sheets that all feed information into a simple summary sheet Occaisionally I will add an extra ROW into one of the feed sheets but cannot get this to show on the summary sheet without manually inserting a row and dragging the first row down to autofil etc For example my summary sheet will http://help.lockergnome.com/office/Excel-Expert--ftopict190049.html#3121504 I would love to work with you on this project I have expertise in Excel Here s more information about me http: www p2w2 com chaitanya_sagar index php Regards Chaitanya Sagar Excel Expert http://help.lockergnome.com/office/Linking-CSV-file--ftopict924219.html#3116025 Excel 2003 Create data import 1 Open Excel and open a new file This will be your new document that will contain linked in data csv files 2 Go to Data menu gt; Import External Data gt; Import Data 3 Browse to the data file you wish to import data from 4 Select file and click Open 5 In the Text Import Wizard select type of delimiter to correctly import your data 6 Click fi http://help.lockergnome.com/office/refreshing-data-linked-dbf-database-file-opening--ftopict1005540.html#3115667 I have a excel pivot table with an external database a dbf file Is there anyway to refresh the pivot table without actually opening the dbf file? When I tried to refresh the pivot table without opening the dbf file first it complain that the link contains one or more database that can not be updated or something like that If I open the dbf file first the the refre http://help.lockergnome.com/office/pasted-Linked-cell-click--ftopict1005264.html#3115226 You can insert both a link and a hyperlink in the same cell 1 click on the cell and enter: =Sheet1 A1 2 then click on the cell and: Insert > Hyperlink > Place in this document and point to the same cell in Sheet1 Gary s Student gsnu200835 Steve Stad wrote: > Can I change a setting to enable going to the tab and cell which is paste > linked into another tab w http://help.lockergnome.com/office/Hyperlink-error-XLT-file--ftopict1004265.html#3111153 Hello to all I m facing a problem that I can t resolve I create two Excel file: A xls and B xls In a cell of A xls I put a link to name CELLB defined in B xls In a cell of B xls I put a link to name CELLA defined in A xls All work fine and I can switch between the two file Now I save the A xls as A xlt: I must open it and create each time a new file An xlt I think that can b http://help.lockergnome.com/office/Linking-pictures-spreadsheet--ftopict1004215.html#3110956 On Jan 21 10:15am philcud wrote: > Good morning > > i have a spreadsheet with links to many thousands of photos i want to > burn this spreadsheet and photos to disc how can i ensure that when i > open this spreadsheet from the dvd that all links will be working > correctly? > > i will be opening this spreadsheet up on various computers > > cheers found t http://help.lockergnome.com/office/Validation-list-drops--ftopict1004102.html#3110454 Excel 2003 SP2 Cell E2 of template P has validation =List and drop down list =Clienti into the cell itself In this sheet there is the named range Clienti pointing to a list into another workbook @ = \\Ntserver\MEREGHETTI\DATI EXCEL\Conteggi\[Listino xls]CLIENTI A 4: A 60 With a macro I create a new workbook through the template P and then I open the workbook Li http://help.lockergnome.com/office/Formula-Automatically-Create-HYPERLINKS-webpage--ftopict1003631.html#3108953 Hi all I am not sure if this is possible but I am trying to create a formula that will automatically create hyperlinks that can display my orders which are kept on separate webpages Currently we do it one by one inserting the hyperlinks by recently browsed pages once we pull up an order and it takes a long time If there is away to have Excel do this hyperlink for me once I enter <em>Using <a href="http://www.gotoassist.com/chris">GoToAssist</a> is the easiest way to view and control another person's computer online. Use it to provide instant technical support to family, friends and customers. Start a session with just one click, and instantly connect with the other party. </em> chris@lockergnome.com (Chris Pirillo) Partner Mon, 13 Jul 2009 06:30:00 GMT http://gotoassist.com/chris/ http://gotoassist.com/chris/ You need these network tools, no matter which operating systems and networks you have to support. <a href="http://support.solarwinds.com/updates/New-Customer.cfm?ProdID=568&campaign=ipmon_DL_lockergnome&CMP=BAC-ipmonDL_lockergnome">SolarWinds ipMonitor</a>: Affordable Network Monitoring for SMBs. Get turnkey network, server and application availability monitoring with SolarWinds ipMonitor v9.0. This easy-to-use, reliable solution for SMBs delivers out-of-the-box availability monitoring so you always know exactly what's up with Active Directory, DNS, Exchange, FTP, Web, IMAP, MS SQL Server, and SMTP. <a href="http://support.solarwinds.com/updates/New-Customer.cfm?ProdID=568&campaign=ipmon_DL_lockergnome&CMP=BAC-ipmonDL_lockergnome">Download your free trial today</a>. Or, try their <a href="http://www.solarwinds.com/products/freetools/">totally free tools</a>! And, through 2/29, save 20% when you purchase <a href="http://store.solarwinds.com/s.nl/sc.16/.f">ipMonitor 9.0</a>. chris@lockergnome.com (Chris Pirillo) Partner Mon, 25 Feb 2008 06:30:00 GMT http://support.solarwinds.com/updates/New-Customer.cfm?ProdID=568&campaign=ipmon_DL_lockergnome&CMP=BAC-ipmonDL_lockergnome http://support.solarwinds.com/updates/New-Customer.cfm?ProdID=568&campaign=ipmon_DL_lockergnome&CMP=BAC-ipmonDL_lockergnome Starting at just $3.99/month, web hosting from <a href="http://www.godaddy.com/gdshop/default.asp?isc=cp2">GoDaddy</a> includes 99.9% uptime, 24/7 support and free access to GoDaddy Hosting Connection, THE place to install over 30 FREE applications sure to help you get the most from your hosting plan and Web site. Enter <a href="http://www.godaddy.com/gdshop/default.asp?isc=cp2">code CP2</a> at checkout, and save an additional 10% on any order. <p>Plus, as a friend of Chris Pirillo, enter code <a href="http://www.godaddy.com/gdshop/default.asp?isc=chris7">CHRIS7</a>, that's C-H-R-I-S and the number 7, when you check out, and save an additional 10% on any order. Get your piece of the internet at <a href="http://www.godaddy.com/gdshop/default.asp?isc=chris7">GoDaddy.com</a>.</p> chris@lockergnome.com (Chris Pirillo) Partner Mon, 25 Feb 2008 06:30:00 GMT http://www.godaddy.com/gdshop/default.asp?isc=cp1 http://www.godaddy.com/gdshop/default.asp?isc=cp1 It doesn't matter if you're running on Windows or Mac OS X - every power user needs either <a href="http://send.onenetworkdirect.net/z/13766/rn_a32755/">Parallels</a> or <a href="http://send.onenetworkdirect.net/z/17081/rn_a32755/">VMware</a> (or both). There's never been an easier way to test software without destroying your primary operating system's stability. Think of how many times you wish you could press a 'reverse' button on your computer. Plus, there's no easier way to try new Linux distributions - see what all the fuss is about. Run Windows in OS X, run Linux in Windows, but the best way to do either is with <a href="http://send.onenetworkdirect.net/z/17081/rn_a32755/">VMware</a> and/or <a href="http://send.onenetworkdirect.net/z/13766/rn_a32755/">Parallels</a>. chris@lockergnome.com (Chris Pirillo) Partner Mon, 25 Feb 2008 06:30:00 GMT http://chris.pirillo.com/2008/02/19/parallels-or-vmware/ http://chris.pirillo.com/2008/02/19/parallels-or-vmware/ <p style="color: red">This feed is fueled by Lockergnome <a href="http://www.lockergnome.com/buy/">Online Shopping and Coupon Codes</a></p> <p> Before you shop next time, see if we have <a href="http://coupons.lockergnome.com/">a coupon</a> first. </p> chris@lockergnome.com (Chris Pirillo) Partner Sat, 12 Jul 2008 07:56:13 GMT http://coupons.lockergnome.com/ http://coupons.lockergnome.com/