unwanted links come when new rows are inserted
Mon, 22 Oct 2007 06:16:01 -0700
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
want to keep this facility), links to info sources from the row below are
also collected an ...
|
Adding rows/columns to linked file
Fri, 19 Oct 2007 18:14:00 -0700
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 IDENTICALLY. I have esatblished
li ...
|
links between 2007 version files and 97-2003 version files
Fri, 19 Oct 2007 12:05:01 -0700
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 97-2003 (.xls) files. Is
there a ...
|
Dynamic link to workbook
Thu, 18 Oct 2007 08:34:38 -0700
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
In the overview workbook I've liste ...
|
wav files in excel open up sndrec32.exe
Tue, 16 Oct 2007 13:59:52 -0000
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
end it
i dont want it to open in the sound recorder
it was opening with windows media player before but after some updates
it changed to sound recorder.
have as ...
|
hyperlink
Mon, 08 Oct 2007 16:43:26 -0000
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
to row 12. Is there any way to do it auto ...
|
Check Boxes
Sun, 7 Oct 2007 11:43:20 -0400
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 manually. I know how
to do this ...
|
|
|
question on links where info is added and cell location is wrong
Thu, 4 Oct 2007 13:34:00 -0700
Hi,
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
cell B5 in Workbook Red into cell A1 in Workbook Blue i ...
|
flagging cells that have been referenced
Thu, 4 Oct 2007 19:36:31 +0100
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'.
--
reedspencer ...
|
not working hyperlink after save
Thu, 4 Oct 2007 13:31:52 +0200
hello,
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?
tx.
N.
from the working hyperlink
\\ts\homedir$\wim.de.smet\diskette 2\MVC-002F.JPG
to this after we saved
...
|
