Find/delete text string

  • Thread starter Thread starter Vinnie
  • Start date Start date
V

Vinnie

Somebody emailed a 1MB workbook with some basic charts and some big
pivot tables/charts. I am supposed to remove all mention of the
company name, "COMPANY", from the workbook.

Normally I wouldn't be afraid - but how can I ensure I remove all
references to "COMPANY" from the pivot tables too?

thanks in advance,

vinnie
 
Vinnie,

I don't know whether this does it, but Jan Karel Pietrese's FlexFind utility
which you can get at which you can get at http://www.bmsltd.co.uk/mvp/ is
probably the most powerful tool for this type of thing.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Not a novice - can't delete tabs! 1
workbook opening takes 2 minutes 5
how to change old data source reference from copied pivot tables 2
Pivot Table New Data 4
Pivot tables - memory issues - please help 2
View Pivot Table Source data as a Data Table 6
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 16
refreshing data in a pivot table changes cell format 1

Back
Top