Posts by nmcorley

An option for external data queries within excel is the "Fill down formulas in columns adjacent to data" which is very useful.

Is there an equivalent for pivot tables?

I have a pivot table that summarises customer information into one line for each customer. Alongside each customer I have an account comment that is obtained using a vlookup from a manually maintained table on another sheet. This allows the credit controller to enter comments against a customer which will remain even if the pivot table is refreshed.

The length of the pivot table is variable so I was wondering if there is a "fill down formulas" equivalent as a neat way of copying the vlookup formula down only when necessary.

Many thanks for any help offered

I have a Pivot Table that is refreshed daily - the date is a Page field in the format 20050822.

What I would like to be able to do within the VBA code that I use to refresh the data is to select the maximum value (most recent date) of this field before saving and distributing the file.

Many thanks for any suggestions

Nick

Sorted

Thanks a lot!

I'm running VBA code to open, refresh and save some workbooks.

By setting DisplayAlerts to false I can suppress some of the Warning Messages but this doesn't seem to cope with the "Update all linked information - Yes/No" Dialog.

Can anybody offer any suggestions?

TIA
Nick

On trying to open a file in XL2000 from a mapped network drive the following error message appears:

"Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space."

Neither memory or disk space are a real problem.

Other Office programs (Word etc.) will open files from the network drive without a problem.

The current workround is to transfer files to/from the hard drive before opening or saving.

Any ideas?

Thanks in advance

Nick