Excel 2007 Error re "features cannot be saved in macro-free workbo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When saving a 97-2003 workbook to the dafault Excel 2007 format get error
message:

"The following features cannot be saved in macro-free workbooks.

*VB Project

To save a file with these features, click no, and then choose a macro -
enabled file type in the file type list.
To continue saving as a macro freee workbook, click yes.

Anyway:

1. Why is the default Excel filetype macro-free anyway. Would have thought
that as a default it would be be set up to store macros?
2. The file I am saving doesn't have any macros that I can see anyway, so
why does it think the "VB project" is present?
3. Is therefore the "Excel Binary Workbook" format the best alternative file
format for saving this 97-2003 file. PS: I want to eventually save it back to
97-2003 as well (and will be careful not to use 2007-only features in it as
well).

I'm obviously missing something simple here I suspect. Any advice?

Also, just a plug for the other hugely frustrating problem that I am having
that I submitted yesterday entitled "Excel 2007 Saving Takes a Long Time and
Consumes EXACTLY 50% CPU" ... if anyone has any ideas about this one I would
be MOST grateful as I suspect I will have to uninstall 2007 and return to
2003 if I can't work round this.
 
Back
Top