Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Help How to update linked .xls offline with MS-ACCESS (VB)? Hi guys, How can get an excel file to update itself offline? The context: TEST1.XLS TEST2.XLS is linked to test1.xls (ie a cell in test2 is ='D:\TEMP\[test1.XLS]test1'!A2) ACCESS.MDB Updates TEST1 and NEEDS updated results from TEST2 The question How can I "request" TEST2.XLS to update itself from ACCESS.MDM before I import it in ACCESS.MDB? Thank you all. -- Don't forge... 1 4/14/2007 1:40:46 PM Counting Specific Number of Days across Multiple Months I have a task which seems relatively easy at first. I have two dates as inputs: a start date and a stop date that can vary between dates and lenght of time. I have a header row with dates by month. I am trying to write a formula that will tell me how many days between the start and stop date are in each month. For example, if I start on Jan 30 and end on Feb 2nd of the same year, I will show... 2 4/14/2007 11:29:49 AM Automatically update data across worksheets I have an Excel worksheet containing 4 worksheets. The main data is in Sheet 1. I need to update certain cells in Sheet 1 regularly and those cells are repeated in sheets 2,3,and 4. My question is can I update the whole lot automatically to save having to open each worksheet every time? -- Lancashire Lass... 2 4/6/2007 11:53:24 AM External app with switches in link Is it possible to launch an external application with its switches, from within a "=HYPERLINK"? Something link this; =HYPERLINK("C:\Program Files\Prog\Prog.exe" & " Switch1 Switch2 " & Range(C6))? -- Scott »--« ... 2 4/3/2007 10:11:27 AM Pivot Table - Reference is not valid I have a list in a file name abc.xls. I have defined the list with a name say XYZ. I have another file Summary.xls with a pivot table that I'm using to give me a summary of that list. The 'XYZ' which is the defined name of the actual list in abc.xls file works when both the files are open. When I open the Summary.xls file, first message says "Reference is not valid" and second message say... 1 3/31/2007 3:18:26 PM Drop-Down List I wasn't really sure how to phrase this one -- this isn't your Typical Drop-Down List. I have a SELECT statement which queries SQL Server 2005 and displays the data in Excel. Let's say that the data queried shows products in 4 different cities, without knowing (in advance) how could I create an input/drop-down field to allow the user to specify a particular city? Below is the cod... 4 3/30/2007 12:31:34 PM Matching Criteria in adjacent columns Here's this one: I want to have a formula that will return the value of a cell that is adjacent to specific criteria in the adjacent cells next to it. For example: Column A Column B Column C Column D Column E Location 1 Product 1 Delvery 1 Return 1 Cost 1 Location 2 Product 3 Delvery 3 Return 2 Cost 3 Location 3 ... 9 3/30/2007 10:02:02 AM Add-ins not working We have Link Finder plugin with Excel 2000 to find and delete external links in excel spreadsheet. It has been working fine. However, with one of the user, on a specific spreadsheet, the "find links" menu item does not show up at all. At the same time, when I open a blank spreadsheet on the same machine, "Find Links" shows up. Even I tried enabling the find/delete links by going to add-ins,... 3 3/20/2007 3:20:55 AM Link to Network Drive I have a spreadsheet which links into an Access database, the database is on a shared drive which I see as the 'H' drive, however there are a few users of this file who see it as their 'K' drive. I need to change the connection from the drive letter to the Network drive path to enable another user to be able to update this data in my absence but I can't see how to so this, any help would... 4 3/15/2007 6:23:32 PM Missing "Link(s)" Hello, I just upgraded from MS-Office 97 to MS-Office 2003. I have 2 files (file A and file B), that where linked to each. If I entered data in file A, file B would show the data I entered. Since upgrading to MS-Office 2003, file A and file B are not communicating. Can/will someone explain this to me, then point me to some examples??? Thank you, Charles ... 6 3/13/2007 11:13:07 PM Updating excel worksheet from an Access Query Morning, I have a Excel spreadsheet and need to add an additional worksheet that links to an Access query. I have tried using Import Data (access database) from excel and it appears it only let me link to a table in access and not a query. I have read about using Microsoft data links but I am not sure how to implement them. What I need to achieve is Excel to run the query (which... 1 3/13/2007 9:21:05 AM Break Link cause Send Error Report I have an Excel 2003 file with 4 tabs. Sheet4 is a roster - dates and names. The first of the date is sourced from Sheet1, the names on the roster are sourced via data validation drop down boxes to dynamic named ranges on Sheet2 and Sheet3. On Sheet1 is a button with a macro behind it that publishes the roster - basically it copies Sheet4 to a blank workbook and breaks the links to th... 5 3/13/2007 1:36:36 AM "don't update" links & calculating cells I have a workbook (A) that has links to and will open 3 other workbooks (B,C,D)when opened. One of these 3 workbooks (B) has links to the other two (C,D). I have the following startup macro. Private Sub Workbook_Open() Application.DisplayAlerts = False Workbooks.Open Filename:= "C.xls", UpdateLinks:=False Workbooks.Open Filename:= "D.xls", UpdateLinks:=False Workbooks.Open Fil... 1 3/8/2007 7:46:46 PM Advanced filter search Gents, I have a problem on one of my spreadsheet where I have a table with data on columns A thru E. What I want is to have a macro which can look in column A for rows having exactly the same value, cut them and paste them somewhere in the bottom of the same sheet but only in one condition. Their values in column E have to be opposite. This is an example. On the below example, A1 and A3 are... 1 2/23/2007 7:58:09 AM Advanced Find and replace Gents, I have 2 cells (A1 & A2) in my worksheet that I change everytime I open my sheet. Their contains exchange rates. And what I want is to have a macro which can look the data on column C and find all data equal to A1 value and relace them by the A2 Value. In the below example it about finding 30 (value on A1) in column C and replace it by 40 (value in column A2). But as I said A1 and A... 1 2/23/2007 7:29:16 AM Problems with my links to an excel 2007 file from a word 2007 file All the charts I have in an msword file linked to an excel file do not automatically update as they did when I was using the 2003 version. Additionally the below pop up window is appeared in the excel file: Microsoft Office Security Options Security Alert-Data Connections Data Connections Data connections have been blocked. If you choose to enable data connections, your computer may no... 1 2/21/2007 10:12:13 AM If I PDF a spreadsheet the Links don't work there - help I have created a PDF from an Excel spreadsheet. All the cells on one column on the spreadsheet have links to data on a website. The links are not transferred to the PDF file. I know how to place the links on the PDF file: Tools > Advanced Editing > LinkTool Then open up a rectangle on the required cells in the PDF and place the link. BUT, if I make changes to the spreadsheet, t... 2 2/20/2007 4:39:09 PM Hyperlink to Embed Object Is there anyway to have a list of hyperlinks to file locations and be able to click on the hyperlink which opens the embedded object. I need to be able to do this with a list of file names. I found a macro that will embed an image object on a list of file names inside the comment box which then allows the mouseover function to work but I have multipage TIFFs that I want to embed. The best ... 2 2/20/2007 4:02:32 PM New excel site Take a look at this new excel site http://faqexcel.blogspot.com ... 1 2/15/2007 1:11:39 PM Preserving links after relocating worksheet files I have a number of Excel files that link to other spreadsheets. The files are located in a variety of folders. Is there a way to relocate all files into the one folder and still maintain all the links. I am hoping that by placing all files in one folder that Excel will look in that folder first to find any linked files. I don't want to have to open all files to get this to work or have ... 1 2/9/2007 9:38:36 PM Break Links in Excel 97 Since Excel 97 doesn't offer a "Break Link" option, how can I break a link between two workbooks? Thanks, Craig. ... 2 2/9/2007 5:31:22 PM Insert Hyperlink shortcut no longer works Here's a weird one... anyone have ideas? I used to be able to easily insert into Excel a hyperlink to web page that is in an open window by using Alt+Tab. Here's how it worked: = In IE, go to the web page you're interested in. = In Excel, go to a blank cell and click Insert > Hyperlink (or press Ctl+K) = Press Alt+Tab to go to the web page IE window = Press Alt+Tab to go back to Excel --... 1 2/8/2007 4:50:29 PM Insert Hyperlink shortcut no longer works Here's a weird one... anyone have ideas? I used to be able to easily insert into Excel a hyperlink to web page that is in an open window by using Alt+Tab. Here's how it worked: = In IE, go to the web page you're interested in. = In Excel, go to a blank cell and click Insert > Hyperlink (or press Ctl+K) = Press Alt+Tab to go to the web page IE window = Press Alt+Tab to go back to Excel --... 1 2/8/2007 4:42:48 PM automatically generate links from a directory and its sub-directories Hi all, I want to create a macro that would provide me a listing of a directory and its sub-directories and create hyperlinks to all the .pdf files in these dir's. I would like to capture the directory names too .Also I would like to updates these links everytime the spreadsheet is opened. My directory structure is : c:\Pending Cases Year_2007 a ... 1 2/7/2007 8:01:33 PM Pasting a Selection as a Picture Hello, I am trying to convert a selection in Excel into a picture within Excel. Whenever I select the cells I want to copy and go to "Paste Special" it gives me only Paste Special with only the selections for "All", "Formulas", "Values", etc... I need the Paste Special that will allow me to paste as a picture. Currently I make my selection in Excel, select Copy, and then do a Paste Speci... 4 2/7/2007 1:10:18 PM 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13