| Thread | Last Post | Replies |
|
| unwanted links come when new rows are inserted | 27 Oct 2007 01:27 GMT | 8 |
If anyone can assist, I'd be most grateful. Firstly, Extend Formats & Formulas to Additional Rows is checked in Oprions under the Tools menu. BUT, as well as extending formats & formulas (which is really useful and I
|
| How to turn off hyperlink screentips? | 25 Oct 2007 23:56 GMT | 1 |
This Q has been asked since at least 1999. Has MS ever fixed Excel to let you disable hyperlink screentips? They are an extreme annoyance. I see people saying that toggling Excel's screentips property doesn't
|
| Dynamic link to workbook | 25 Oct 2007 07:42 GMT | 3 |
I have a overview workbook (Status.xls) were I compile data from other source workbooks (artnr1.xls, art.nr2.xls, ...). All source workbooks look the same, it's just the data that differs. When a new source workbook is created it's saved as [article number.xls] eg, 11134.xls
|
| Can Excel actually point to filenames on disk? | 25 Oct 2007 02:48 GMT | 2 |
I have an Excel worksheet that displays the names of files on my hard disk. But I want the names to be actual pointers to the files, not just names, so that if I rename or even move a file, its path will
|
| Strange hyperlinks | 23 Oct 2007 19:13 GMT | 2 |
We use Office 2003 Sp2 on XP Sp2. I have a user that opens an Excel worksheet that has hyperlinks. However the hyperlinks don't work for anybody. If I look at the hylerling address, it looks like
|
| Adding rows/columns to linked file | 20 Oct 2007 08:21 GMT | 1 |
I have 1 master workbook and about 20 children workbooks. The children are excel spreadsheets with several rows and columns of budget data. The master workbook is one huge spreadsheet with all of the data from the other children on one sheet. ALL WORKBOOKS ARE FORMATTED ...
|
| links between 2007 version files and 97-2003 version files | 19 Oct 2007 23:24 GMT | 1 |
Say you have a big collection of excel 97-2003 format files (.xls) and a lot of them have links between each other. Your department plans to make the move from Excel 2003 to Excel 2007. New files that you create are saved as 2007 format (.xlsx) and they want to link to the ...
|
| flagging cells that have been referenced | 18 Oct 2007 15:52 GMT | 3 |
Is there anyway to flag a cell in worksheet 'questions' that has been referenced in worksheet 'test'. Example: In worksheet 'test', cell D3, I enter =questions!C15. I want to know that cell C15 has been used in worksheet 'test'.
|
| link won't open | 17 Oct 2007 22:24 GMT | 2 |
When I try to open the following link Internet explorer won't open it, what does the :80 in the link mean? http://exceltips.vitalnews.com:80/ TIA
|
| wav files in excel open up sndrec32.exe | 16 Oct 2007 17:50 GMT | 2 |
XL2002 inserting hyperlinks to WAV files clicking on links opens up sndrec32.exe it opens only in the background ie we need to go to task manager to
|
| hyperlink | 09 Oct 2007 12:10 GMT | 2 |
I am using hyperlink to connect cell 1 in a spreadsheet with another cell (suppose in row 12) in the same spreadsheet. When I insert a row before the connected cell (so, now it's row number becomes 13), however, the hyper link does not change automatically but still link
|
| Check Boxes | 09 Oct 2007 12:10 GMT | 1 |
I created a form in a sheet of an Excell 2000 workbook that will print out on an 8.5 X 11 paper. The top half of the form -- the part filled in manually is an exact duplicate of the bottom half. I want the bottom half to fill in automatically as the top half is filled in ...
|
| fomula tracing | 06 Oct 2007 06:44 GMT | 2 |
I am handling a very large financial model. Using fomula tracing tools, I can double click the dotted line and go to the another spreadsheet giving input to the current sheet. My question is the following:
|
| question on links where info is added and cell location is wrong | 05 Oct 2007 07:27 GMT | 1 |
I have a question on excel links. Say a user has 2 workbooks, Workbook Red and Workbook Blue. In Workbook Red, a user has a 3 credits in cells B2, B3, and B4 that are added together and shown as a total in cell B5. The user creates a link from
|
| not working hyperlink after save | 04 Oct 2007 16:53 GMT | 1 |
in office 2003 we have the problmem that when we make a hyperlink, to a share in our nw, it works fine, but when we save the sheet, it doesn't anymore. Can someone help us out?
|