I had the same problem and here's my solution. It apprears that when ever you save an excel speradsheet to a network drive it changes all the hyperlink...

Hi, For some reason the calculations made in my Excel documents require a manual action, instead of being executed automatically. I have tried switching to...

I have a macro in one of my sheets of a 9 sheet file (run by ctrl z). Is there anyway to have it run automatically when I first open the file. If so,...

I can't figure out how to do math forumlas useing feet and inchs taken off shop drawings. i am useing office 2000. i dont see any format for feet ' or inches...

I am running Execl 2002 SP2. It has suddenly started opening new sheets in mirror arrangement (Column A on the right and all scrolling controls reversed). ...

Hi all Is it possible to have a formula which recognises whether to select or delete data. Eg; A1 = xxx A2 = yyy A3 = zzz

I have Excel 2000, and I use Paste Links often. Sometimes one of my files seems to get "infected" in such a way that when I open it, I get a "File Not Found"...

hello all, I have a macro that runs fine, the problem is it relies on user input, and will run even if the data received is invalid. I can calculate simple...

I have created a spreadsheet that is to be completed by several people. Some of the cells in the spreadsheet are protected appart rom the ones to be completed...

When I open a particular workbook i always find the headers are strikethrough, I need a help on how to remove this strikethrough, note this is not on the cells...

This is silly but I have not been able to locate the Help item online: Recently I used the Reviewing toolbar. I deselected it when I opened Excel this...

I would like to create a 'Read Only Folder' or a 'Password Protected Folder' in which I can add spreadsheets to without having to individually protect each...

I am looking for a formula that's going to look at column where there are multiple text entries and return a list of all distict entries. For example, Column...

Hi, When using check boxes, no matter how much I resize the area, the actual check box itself never gets larger (only the area for a description does). Is...

Hi, Could anyone tell me if it is possible for excel to return information about a document in a folder? I have several pdf's in a folder on my c: drive. Is...

I have 3 dates within a month to make cheques,as per Bills received. Below is the matrix for the same. Received Paid on 23rd to 5th ...

I am running Excel 2000 on Windows 2000. I have created a small spreadsheet (25.5 kb)with several hyperlinks. When I try to save it to the network share I...

Hello, I need some help. I am trying to extract values only from cells that are a specific color (in my instance, yellow) is there a function that will allow...

Jan: I've faced the same issue with an excel file that contains hyperlinks to sheets within the same document and no macros. The earlier suggestion (MS Kbase...

Setting up excel spread sheet want to be able to hot key from any cell back to a given cell. ie: from g15 back to a3. Any help appreciated