Saving selected areas
 

I have many users who add data to an Excel workbook. Once per month
individual users highlight their entries and then save these as new workbook.

The problem is that for some reason Excel is now saving all the workbook
instead of just the highligted cells.

Has anyone any idea why it isn't now when it has worked before?

Dave,

Excel saves the entire workbook. Always has. Certain file types (Save as)
save only the active sheet (*.csv, *.txt, etc.). The save as, web page
(html), has an option to save only the selection. Could you have been
using that?
--
Earl Kiosterud
www.smokeylake.com

"Dave S" wrote in message
...
I have many users who add data to an Excel workbook. Once per month
individual users highlight their entries and then save these as new
workbook.

The problem is that for some reason Excel is now saving all the workbook
instead of just the highligted cells.

Has anyone any idea why it isn't now when it has worked before?