I want to be able to copy tabs from workbook to workbook. However, when I right-click..'choose Move or Copy' and copy the tab into a new workbook, the formula...

I have 2 worksheets in a work book. One is a list of over 7000 assests that we need to inspect. The other worksheet is the information that will be collected...

We have an EXCEL spreadsheet that has been created with Automatic links. When you send this EXCEL spreadsheet to a user that have EXCEL XP office, the user...

Hello , Here is my problem . I have created a workbook template for balancing reports. In the workbook there are columns for previously balanced reports...

I am trying to link some columns using the Paste Special to another worksheet in my workbook. When I link them, all of the blanks in the original show up as...

I have some files that I have upgraded from Excel 5 to Excel 2002. While they contain links when I open them in Excel 2002 and select Edit, Links the area is...

Win98, Office2000. I have a worksheet with several hundred rows. Each row has a link to a text file in the same directory. Is there a way to verify the links...

Hi all... I have a large worksheet and a smaller version of it. I have created columns on worksheet 2 that are columns in worksheet 1. When I change a cell in...

Function: under Data - Get External Data - New Web Query good day friends, i would like to query the stock quote copy to the data to the spread sheet by...

I have a spreadsheet that uses ODBC/MS Query to connect to a database and pull in part numbers each time the worksheet is opened the file refreshes. The part...

Hi, I am working in one workbook: Sheet1 is the Master of approx 50 columns by 1400 rows. That data is refreshed daily from a .txt file. The sheet normally...

I'm trying to link a sheet from one workbook to a sheet in another workbook, and to update the info when it's changed on a daily basis...can...

Could anybody recomend me a good book to learn EXCEL from a beginner to using all functions Tom G.

I have a spreadsheet with a bank of index buttons at the top that are linked to separate series of data blocks listed below. The panes are frozen right below...

I created a link using the "create hyperlink" button. This links to a directory on my drive. I test the link and it works. The instant I save the file, the...

I have 6 excel files which are to be opened in a sequence. Any help regarding writing a macro to do that?

Hi, Can anyone advise me on this? I have a 3 x 3 matrix with columns A,B,C and rows 1,2,3. Each cell contains a simple link such as (=J6) but all 9 links...

It seems I have email addresses in my spreadsheet that have lost their ability to hyperlink. How do I get back? -- Christine L. Anderson

I have a workbook with many named cells. A second workbook has links back to the first workbook. When I open the second workbook via an UNC path, rather than...

I am trying complex linking project and was anyone knowledgeable to help me....this is the situation.... I have 4 workbooks that I want to link to a 5th...