Have a six-sheet dynamic file that needs to be turned into a static report
each day.
Normally no problem --- file save as whatever / select all sheets / select
all cells / copy / paste values.

But there are pc Excel 2007 tables in the file, graphs, and live query links
to Access.

When I email the file, anyone with Mac Excel loses calc cells in the tables
[they become #value#], which then knocks out the graphs/etc.

Need a sub-routine that will first convert all tables in the file to ranges,
then value-copy everything.

Can anyone assist?
Thanx in advance.

- Mike