I am simply reposting the solution I found on
http://help.wugnet.com/office/errors-opening-excel-ftopict1059316.html#
But it wasn't that easy to find... I missed it the first time.  And a
few newsgroup topics on this subject didn't have the answer.

When the folowing formulae are entered into a cell in excel...
This yeild the value "false":
=AND(L1>INDIRECT(ADDRESS(ROW($A4),COLUMN($AD4),
4,TRUE,"data")),L1<INDIRECT(ADDRESS(ROW($A4),COLUMN($AE4),

When the folowing formulae are entered into a cell in excel...
This yeild the value "false":
=AND(L1>INDIRECT(ADDRESS(ROW($A4),COLUMN($AD4),
4,TRUE,"data")),L1<INDIRECT(ADDRESS(ROW($A4),COLUMN($AE4),

I get the following message when loading Excel 2007: "Excel experienced a
serious problem with the c:/program files\microsoft
office\office12\library\lookup.xlam add- in. If you have seen this message
multiple times, you should disable this add-in and check to see if an update

When the same are used in conditional formatting, there is no change
in appearance of one cell or the other.  I am trying to format
conditionally some cells based on the values in another sheet.  I can
do this with the indirect statement, but not in combination with AND.

Where can I find some good information on queries in Excel. I can now
connect to the Access database within Excel, and run a working query.
However, I need total control in laying out where
the query results go. How do I do this? For example, I may want to

I try to create a link which provide value, where the link path is determine
from another cell, unfortunately b8 return a string value.  How to make it
evaluate to return actual value of c:\abc.xls category worksheet $a$8 value?
           a                       b

I have an Excel workbook that is used on multiple workstations that I want to
print using a specific print driver on a network printer. When I record the
macro and choose the printer it adds the server path and "Ne12" to the end of
the printer name ie "\\servername\RICOH Aficio ...

I recently added password and write protection to some workbooks.  Now the
files have disappeared.  The folders they were in show up as files now with
no file type or extension.  When I open them in notepad the data is
unreadable.  I had a backup of one that I copied over to a ...

mysql01 = " SELECT  "
  mysql02 = " ChildRecords.ChildID "
  mysql03 = " FROM ChildRecords "
   ActiveWorkbook.Worksheets.Add

I'm trying to help my department make use of the DDE function of
excel.  Basically, this means opening a worksheet with specific
formulas referencing a trade platform client they have installed.
Then they should be able to select the 'Transition Formula Entry'

I have the same problem. It does not matter what type of computer you have I noticed this error happens with both Excel 2003 and 2007.
So far I have not found a solution for this but I can replicate it on every single Win Vista machine I set up.
So far Microsoft has remained silent ...

Does anyone have a template for tracking football picks?
We play straight picks each week with total score of the Monday night game
used as the tiebreaker. I would like an excel sheet that can be set up to
auto calculate and keep running total. I have one I have somewhat created

This is an odd one - I've got a spreadsheet that I've been printing
quite happily on legal-sized paper.  When I print the same document,
however, on 11 x 17 paper, exactly one of the borders is not printing
- it's the border between Column C and Column D.  There are absolutely

I have an excel file with many sheets in it. One entitled "eom proj" which I
had a graph in it with my end of month projections until the end of the
year. I noticed today that someone had removed the graph, but when I tried
to insert another chart, all the options had been grayed ...