Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Formt of Linked cell Hi I have links in the cells of one worksheet to cells in another worksheet. I want not only the value of the other cells to be linked, but also the formatting to be linked. Is there any way to do this? Thanks.... 1 2/22/2006 11:16:30 AM Excel Links Update I have a problem getting my workbooks to update with the most recent data. For example, workbook A passes data to workbook B, B then passes data to workbook C. If data is updated in workbook A, workbook C does not update until workbook B is opened and saved first. In Office 97 I could open workbook C and the data would update without opening workbook B first. After our new upgrade to Off... 1 2/21/2006 1:48:53 PM Excel Links Problems My office recently upgraded from Office 97 to 2003. Since doing so our linked Excel Workbooks have been getting a #REF error when opened. I have now re-established the links between workbooks (19 in all) and we no longer get the #REF error message. However, I have now unknowingly created a hierarchy of linked workbooks: Data or source workbook A; then target workbooks B; then final T... 1 2/20/2006 6:10:29 PM hyperlink base did not save Using Excel 2003, when we create a new spreadsheet, if we specify the hyperlink base, it is not saved when the files is closed. However, we have some files that do save the hyperlink base. They might have been saved with another version of Excel, I don't know. If these files are copied or saved-as, the copies also work. On the files that work, the hyperlink base can be deleted, and lat... 2 2/17/2006 11:53:26 PM Change Source / Update Now buttons not available My problem is that I want to change the source workbook but the Change source button is not available? The source file updates weekly (one for Monday, tuesday, etc). Before these files are updated, they are archived to a different folder but all under the same name (i.e. MON TUE WED etc.). I want my formulas to compute using the archived files but the Change Source button is not available! I had ... 1 2/16/2006 10:33:40 PM I can view links, but can't delete them I have an Excel spreadsheet with links to several Excel spreadsheets that have been deleted. I can view the links by clicking on Edit and Links, but there is no option to delete them, only update now, open source, and change source. Any ideas on how I can delete all my links?... 5 2/16/2006 10:28:46 PM Change links on moving to CD or another computer I have a large number of Excel files with links to some common data files all held in teh same directory. How do I copy these to a CD in a way that changes the directory references to reflect the new directory they are in - either on the CD or when copied to another computer. Thank you Rich80105... 1 2/16/2006 7:21:36 PM Linking multiple files -- We have a daily schedule sheet that our power marketers use to enter their daily power sales and purchases. Each schedule is saved in a separate file by using the date as the filename, (i.e. m20060101, m20060102, m20060103… etc). Is there a way to combine all this data into one file so I can eventually link it to an ACCESS database for various reports. There are also situati... 1 2/10/2006 10:26:37 PM automatic updating of javascript downloadable data Hi, I want to have an excel office 2003 professional spreadsheet automatically update its data from a website. In order for me to manually get the data into the excel spreadsheet, I have to log into the website with a username and password, then click on a link that opens a popup window which contains a button I have to click on to download the excel data to my harddrive. Then I open ... 1 2/8/2006 5:17:28 AM can't change field name in query? I'm using Microsoft Query to bring in some data. I have the query in SQL so i can do some groupings and count values in one of the fields. My problem is I'm having difficulty renaming a field, so it comes back with no name at all. The SQL line is: SELECT [lots of fields], Count(StudentHistory.Status) AS CountStatus The count comes back properly, but the changed field name (i.e., Coun... 5 2/7/2006 7:48:37 PM importing links from access to excel to template I have a query in access 2003 that I am analyzing with the tools option in excel. In excel I have created a template which is linked to the imported excel file. Once the access is in excel, I am opening the template -- which should bring over the information from the access to excel worksheet. The information does come forward, but is not in the right location even though the cells/rows an... 2 2/5/2006 6:42:32 PM Linking multiple cells efficiently I have Excel 2002 and would like to link 2 columns across 2 workbooks. I know how to link the cells across workbooks one at a time, but I am wondering if there is way to link columns at time. for example: In the following example, I could first link 1a to 1b, then 2a to 2b then 3a to 3b. Is there a way for me to select the cells 1a:3a in workbook 1 and directly link them to cells 1b... 1 2/1/2006 3:05:27 AM Creating ODBC link within SELECT statement Is this possible. To explain myself, here is my situation. I created an Excel Spreadsheet that uses an ODBC link to a SQL database. In order for anyone to use this file on their PC, that same ODBC link must be setup. Is their some code I can use within a Select Statement that will allow me to bypass having to create an ODBC on everyone's PC? Thanks. ... 3 1/31/2006 6:54:49 PM Query from within Excel I have a need for some query help and I will try to explain my situation. Thanks in advance for any help. I have an Excel spreadsheet that has two different sheets. One one sheet called "Data" I have created a query that pulls AP Invoices from from a SQL database. In the results of this query I may have several lines with the same Company. Ok here's my question. On my other sheet page... 2 1/31/2006 6:37:48 AM worksheet size limit Why are the cells limited to 256 columns and 65,536 rows? Once a format is set and then you realize its limits, its too late and too cumbersome to reorganize the sheets. Are there any future restructuring of these limits to a more even distrubution of rows and columns (30,000 X 30,000) by Microsoft? ... 3 1/30/2006 11:48:20 PM Cell display I created a workbook that has a summary page with cells that link to cells in other pages of the workbook. These cells are in date format. When there is no entry in the cells of the other pages, the summary page cell shows 1/01/1900. I would like the cell on the summary page to be blank if the linked cell is blank. Does anyone know how to do this? -- Thanks... 3 1/30/2006 11:44:58 PM Access Form In An Access Report (SubForm) Question I want to cycle through an excel with multiple worksheets, and showing the first cell of each worksheet (which has drawings in that cell) on a report. I must change the source path with VBA Code. So I use a Form with an Unbound Object Frame (OLEUnbound4) Linked to an excel worksheet, there is a link source path to the excel file and a image on that Unbound Object Frame (OLEUnbound4). ... 1 1/27/2006 5:54:01 AM building a web site I just got back working on my website. Its taken a long time to finish but I am getting there. I got great web hosting at http://www.domainnamefree.net where I got a free .com name and a good site builder. Im going to keep working on it ill let you all know how im doing. Paul ... 1 1/27/2006 1:26:43 AM Changing source on multiple workbooks We have one main workbook that the supervisor fills out that lists jobs, times staff etc. I've just set up links to the daily worksheet workbooks that automatically fill in which staff member is doing which jobs each day. But the problem is, the supervisor makes a copy and changes the name of the main workbook weekly so that the sources for the other 7 workbooks are now wrong. I've shown ... 2 1/26/2006 9:08:44 PM Workbook with phantom link When I open the workbook excel asks if I want to update links to other workbooks. There are no links, I have searched all the worksheets in an effort to delete them but cannot find any. Does anyone have a suggestion? When I go to properties excel shows me the link and the name of the worksheet the link refers to. I select all the worksheets and do a search for the link but cannot fi... 4 1/23/2006 10:08:59 PM How can i make link to different sheet Dear all. i have 5 excell sheet, 1 - work unit rate employee list 2 - time unit rate employee list 3 - schedule employee list 4 - Aramco employee list 5 - All employees list ( work unit + time unit + Aramco unit + Schedule ) My quetion. 1. I would like to make link all sheet. How can i do it? 2. when i add new emplyee records, it should go to relative unit sheet. So please help m... 1 1/22/2006 5:48:54 AM Hyperlink to Outlook Public Folders I am running Office 2000. I have created a hyperlink from Excel to a specific public folder in Outlook using the link:- Outlook://Public Folders/All Public Folders/Foldername The link works but opens another copy of Outlook in a separate window. I want the link to go to the copy of Outlook that I already have open. If I put the <> symbols at either end of the link as recommended... 1 1/18/2006 10:37:02 AM Free mp3's <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>And much more that that!</P> <P><A href="http://forum.saait.net/">http://forum.saait.net/</A></P> <P>This site offers free and legal mp3's, software, movies, games.<BR>They also have a l... 1 1/18/2006 2:31:51 AM Linking Excell values to word document Hope this is the right group - I found nothing suitable for microsoft word. I have a word document with embedded excel sheets that link to a master excel file. When I change values in the master excel file I want to be able to open the word document and print with all the new values calculated but it does not update unless I open each embedded sheet in turn befor printing. How can I get ... 1 1/17/2006 8:56:34 PM Prevent error messagebox when refresing querytable from the web fails Hi, I have an excel workbook with a querytable on a sheet The querytable retrieve data from a web site, and I need that data to be checked automatically, and saved when some data is changed. So I create a class to implement QueryTable events, and I have my own code in AfterRefresh, which saves changed data I need this to be checked and saved automatically, regardless if I'm in from of P... 14 1/17/2006 1:24:48 PM 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13