M
MikeF
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
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