When I create a hyperlink to an external website in excel and click it it gives the following error message "This operation has been cancelled due...

Bill Manville Wrote: Not sure I follow the scenario. How about recording your actions when doing it manually, using the macro recorder. That's just...

Actually, I reckon that I can do it another way: Open the other workbook. Select the required sheets. Copy them to the master workbook. I've just recorded...

Hi, I was wondering - I need to iterate through a set of identically formatted workbooks (values will be different in key cells of course). For each...

Okay....I have 2 workbooks that are linked to each other, easy enough..... Lets say I have a workbook called "09-05 A" and "09-05 B" and each workbook has a...

I HAVE A FOLDER CONTAINING MANY WORKBOOKS THAT ARE LINKED TO EACH OTHER. WHEN I COPY THE FOLDER, THE WORKBOOKS REMAIN LINKED TO THE WORKBOOKS IN THE ORIGINAL...

Hello all. I'm coming up against what seems a rather odd quirk in Excel, and wondered if anyone could confirm it for me and, ideally, help me work around...

Some of my users have impressive collections of linked worksheets. We are at the moment migrating our files to a "Windows sharepoint...

I have 2 worksheets in excel. The first one is imported from my access database. The second is linked to that worksheet. I need to email the second sheet to...

Hi Sir this is Gio from Philippines...... it's my first time here in this site... i am wondering how can i solve this problem in excel and please help me.. I...

Using Outlook 2003, I composed an e-mail at linked to two files on our organization's server, one an Excel spreadsheet with four worksheets and one an .mhd...

Hello I am an Excel dummy.... I like to link from one Sheet to another Sheet (different Workbooks). Currently I found only a way to copy the sheets across or...

I have dual monitors in which I open two different worksheets. When I try to link from the worksheet on monitor 1 to the worksheet on monitor 2, it will not...

I have six spreadsheets. Each links to 6 different data spreadsheets. I just moved all of these into a couple different folders for easier maintenance. Now I...

I have a spreadsheet that I work up quotes on. Using the control toolbox I have created drop down lists to select certain items for calculations on the quote....

Can anyone direct me to a site or give some direction in linking an access database with excel? I have attempted getting external data - creating a new...

Chester1 wrote: Please can anyone tell me how to remove links inspreadsheets If you refer to hyperlinks: Just right click a link or a cell containing a...

I have spreadsheet A and spreadsheet B. I update A each day and need to copy that info to B as well. I set up a link from A to B and it worked fine. My problem...

I've created a spreadsheet that use internet hyperlinks. When the spreadsheet is sorted, the text moves but the hyperlinks stay where they are. Is there any...

Bill Manville Wrote: A better method of bringing data from Access into Excel would be to use Data / Import External Data / New Database Query. ...