I have a linked worksheet on our network. One of the links broke and I went ot fix it but when i pastye special i am seeing a different screen. This screen...

Hello there, I need to create a workbook with a text field that is linked across the entire workbook. However, should any changes be made on any one of...

I input some value say in G5 on sheet1, then using this value and different formulas to get four different results on say A5, B5, C5 and D5. (All on same...

I have a workbook with various links to other workbooks. In this dependent workbook I have 12 columns JAN to DEC. When I open the dependent workbook all the...

Hi people, Posted this to the vba newsgroup before but it seems pretty much dead and this group seems more appropriate. Referencing non contiguous ranges in...

I am trying to open an email from within an excel spreadsheet using hyperlinks but I keep getting errors like "cannot open this file". Any suggestions?

Hello, We have a workbook that contains links to several other workbooks. However, one of the links listed in 'Edit, Links' is not valid and the file no...

I have a workbook I keep on my computer for each current job we have going. Each workbook has several different sheets in them. I would like to take one sheet...

Hello, I'm running windows 2000 and am having problems linking an excel 2002 spreadsheet w/ graphs with another 2002 spreadsheet (I created both). I do a copy...

Hello, In the office I have several hundred excel spreadsheets & many of these are linked. The problem that I am having is that all of the files are on a...

Hi All, Are there any way to link the number of emails received on particular folder? Thanks in advance for the information, Inung

Hello all, Is there a way to show the (full) name of links in a range of cells. I know you can do this manually with "findlink", but am looking for a way that...

I have a worksheet with 60 cells containing hyperlinks to 60 PDFs which reside in the same folder as the EXCEL file. I would like to be able to transfer this...

I have a external database to link MS Access Query. I can run the query from Excel, but I need pass the start date and end date to the query. Are there any...

Dear all: When I embed excel into powerpoint I can actually edit the sheet by double clicking on the object. However, I cannot seem to be able to access the...

I noticed that a few people had problems with #name errors when upgrading. I had a similar problem today but was fixed when I checked the add-ins that I had...

i would like to run a macro that does the following. start at row 2 if L2 and m2 and n2 are all zeros then delete row if not then go to next row and do the...

I am trying to link from one workbook to another. The source position changes, for example product 121.1 might be one cell lower because a product 120.1 was...

I have an excel work book downloaded daily. The workbook contains pricing. On occasion the pricing will move from cell to cell. Is there a way to define the...

I am only a novice at code but have recorded and then added bits to the following code which extracts data from a MS Access database. I have placed it with...