Updating Links Option

[Dave]

When I get the message "This workbook contains links to other data sources"
I can't imagine what "other data" they are referring to. How can I find out
the source of this "other data"

Thanks in advance
Dave

 

[Dave Peterson]

When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

It does a much better job searching for them than I can do.

 

[Hugh Stanley]

Anyone know something like an "if even" function?

I'm interested in if a grid is even, that a certain function be
performed on an adjoining grid, if odd, something else...

Thanks,

- Hugh -

 

[RagDyeR]

In Help lookup "ISEVEN".

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Anyone know something like an "if even" function?

I'm interested in if a grid is even, that a certain function be
performed on an adjoining grid, if odd, something else...

Thanks,

- Hugh -

 

[Dave]

Dave - Thanks much , works like a charm.
One additional question if I might. UNziping the file leaves one with
findlink.xla extension file. Is there some place I can place that file so
it will activate every time I open Excel, or does it have to be a separate
stand alone program?

Thanks again -

Dave

 

[Pete_UK]

Hugh,

I would suggest you use the term "cell". There is a function ROW()
which returns the row number that the cell is on, and there is also a
function MOD( ) which gives the remainder after division. So, the
formula:

=IF(MOD(ROW(),2)=1,"odd","even")

would enable you to do something instead of "odd" for odd-numbered rows
and do something else instead of "even" for even-numbered rows.

Hope this helps.

Pete

 

[Dave Peterson]

..xla files are excel addins.

You can do a few things.

#1. Put it in your addin folder. For me (xl2003 and winXP), it's:
C:\Program Files\Microsoft Office\OFFICE11\LIBRARY

#2. You can put it in any nice safe folder.

#3. You can put it in your XLStart folder. For me:
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART

If you choose #3, each time you start excel, this file will open.

If you choose #1 or #2, you can use Tools|addins (and browse to that folder) to
load that addin each time excel starts.

And you can turn it off just by deselecting it in the Tools|addins dialog.

Personally, I put it in a nice safe spot. But I only open it when I need it. I
just file|open to have it available. (I don't need that tool open that often,
so it's open on demand for me.)

 

[Dave]

Well excellent -
I'm starting with option #1 - looks good to me. Only time will tell I
guess.

My Excel is from Windows 2003. Had 2000 before. I was dumbfounded to find
the options, and what Bill Gates selected as default options, when I went to
2003. (Comment applies to both Excel and Word.) A link tracing routine
seems like such an obvious utility it's hard to believe they passed it up in
favor of some of the junk they opted for.

Anyway, thanks for saving the day for me. Now on with my income tax.

Best regards, and thanks again.

Dave