Recent content by pbrodsky

It sounds as though you want something like: =IF(AND(total1=total2,total1=total3),"true","false") where total1, total2 and total3 are the totals for a particular person from each pivot table. You could get those totals using a "GETPIVOTDATA" function (look at the help files).

Pivot table then, with a translation table and an extra column with a VLOOKUP added to the data each time the .csv is imported. It's more awkward than using Access but will do the job.

From the Microsoft help file: Create a name to represent a formula or a constant Show All Hide All On the Insert menu, point to Name, and then click Define. In the Names in workbook box, enter the name for the formula. In the Refers to box, type = (equal sign), followed by the formula or...

What does the link itself (the URL) look like? Does the URL change, and if it changes, are do the changes follow a pattern? Does the service require a login/password?

I really don't think there is any such built-in feature, and from your description it is not clear how a pivot table fits in. If you describe what you are trying to do, there is probably some way to program it.

A size in pixels only has meaning for bitmapped images, which an InDesign document is not. Presumably if you know the resolution that is going to be used to display the document (not usually something you have control over), you could calculate a conversion.

Actually, even just cells.select

activesheet.cells.select

What about a 'createdate' field? From the Word help: Field codes: CreateDate field Show All Hide All { CREATEDATE [ \@ "Date-Time Picture"] [Switches]} Inserts the date and time that a document was first saved with its current name, as recorded on the Statistics tab in the Properties dialog...

docmd.setwarnings

Nwver mind - I forgot that you said TOC.

Table "Heading Rows" is different from a Heading style. Which are you trying to achieve. If it is setting Heading Rows, I believe it needs to be the entire row.

That symptom indicates that files you linked to were either open when you created the links and then saved to different directories, or were originally in the same directory as the linked file and then moved to different directories, or you changed the directory of the linked file. Excel tries...

Look at the help for the "ref field". That might do what you want.

Are you working with a .xls file in "compatibiity mode"?