I have 7 excel files that I am trying to combine into one document. The files have data and bar graphs. I have tried to use the "Tools">"Merge Workbooks" function on my mac but the option remains gray (I can't click on it). Any suggestions on how to merge these files into one workbook without having to copy and past everything and reformat the graphs? Thanks so much
- Sara