A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Built in Excel 2003 need to convert to 2007



 
 
Thread Tools Display Modes
  #1  
Old June 2nd, 2010, 10:57 PM posted to microsoft.public.excel.misc
tkelly
external usenet poster
 
Posts: 2
Default Built in Excel 2003 need to convert to 2007

I have built a spreadsheet in 2003 with macros, advanced filtering and
vlookups. I open it 2007 compatibility mode, but have found as I develop the
spreadsheet further I am being warned of more compatibility issues. I need
to be able to use all the 2007 features to move forward so how do I convert
what I already have from 2003 to 2007? Is it as simple as changing the Save
As format to Macro Enabled Workbook? I don't want to re-create everything.
Thanks!
  #2  
Old June 2nd, 2010, 11:30 PM posted to microsoft.public.excel.misc
Don Guillett[_2_]
external usenet poster
 
Posts: 607
Default Built in Excel 2003 need to convert to 2007

xl2003 should be able to be forward compatible whereas 2007 may ?? NOT be
backward compatible.
You should?? be able to just save as an .xlsM fileclosereopen in xl2007.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tkelly" wrote in message
...
I have built a spreadsheet in 2003 with macros, advanced filtering and
vlookups. I open it 2007 compatibility mode, but have found as I develop
the
spreadsheet further I am being warned of more compatibility issues. I
need
to be able to use all the 2007 features to move forward so how do I
convert
what I already have from 2003 to 2007? Is it as simple as changing the
Save
As format to Macro Enabled Workbook? I don't want to re-create everything.
Thanks!


  #3  
Old June 2nd, 2010, 11:36 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Built in Excel 2003 need to convert to 2007

Should be as easy as Save as 2007 macro-enabled workbook.....*.xlsm

What compatibility issues are you being warned about?

Do you have some specific messages you could post?



Gord Dibben MS Excel MVP

On Wed, 2 Jun 2010 14:57:02 -0700, tkelly
wrote:

I have built a spreadsheet in 2003 with macros, advanced filtering and
vlookups. I open it 2007 compatibility mode, but have found as I develop the
spreadsheet further I am being warned of more compatibility issues. I need
to be able to use all the 2007 features to move forward so how do I convert
what I already have from 2003 to 2007? Is it as simple as changing the Save
As format to Macro Enabled Workbook? I don't want to re-create everything.
Thanks!


  #4  
Old June 3rd, 2010, 12:52 AM posted to microsoft.public.excel.misc
tkelly
external usenet poster
 
Posts: 2
Default Built in Excel 2003 need to convert to 2007

The compantibility messages were delivered when I was opening .xls format in
2007 compantibility mode and using the conditional formatting options
available in 2007 then saving as .xls.
Since posting the original question I changed the file format to .xlsm and
have not received any compatability notifications.
I have ran my macros and they are working so I guess I am good.
Thanks for confirming that it is as simple as a change of file format.


"Gord Dibben" wrote:

Should be as easy as Save as 2007 macro-enabled workbook.....*.xlsm

What compatibility issues are you being warned about?

Do you have some specific messages you could post?



Gord Dibben MS Excel MVP

On Wed, 2 Jun 2010 14:57:02 -0700, tkelly
wrote:

I have built a spreadsheet in 2003 with macros, advanced filtering and
vlookups. I open it 2007 compatibility mode, but have found as I develop the
spreadsheet further I am being warned of more compatibility issues. I need
to be able to use all the 2007 features to move forward so how do I convert
what I already have from 2003 to 2007? Is it as simple as changing the Save
As format to Macro Enabled Workbook? I don't want to re-create everything.
Thanks!


.

  #5  
Old June 3rd, 2010, 12:56 AM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Built in Excel 2003 need to convert to 2007

The error messages when saving as *.xls would be expected when using 2007
features that are not available in 2003.

So now you have saved in 2007 format you're OK as you have found.

Thanks for the feedback.


Gord


On Wed, 2 Jun 2010 16:52:01 -0700, tkelly
wrote:

The compantibility messages were delivered when I was opening .xls format in
2007 compantibility mode and using the conditional formatting options
available in 2007 then saving as .xls.
Since posting the original question I changed the file format to .xlsm and
have not received any compatability notifications.
I have ran my macros and they are working so I guess I am good.
Thanks for confirming that it is as simple as a change of file format.


"Gord Dibben" wrote:

Should be as easy as Save as 2007 macro-enabled workbook.....*.xlsm

What compatibility issues are you being warned about?

Do you have some specific messages you could post?



Gord Dibben MS Excel MVP

On Wed, 2 Jun 2010 14:57:02 -0700, tkelly
wrote:

I have built a spreadsheet in 2003 with macros, advanced filtering and
vlookups. I open it 2007 compatibility mode, but have found as I develop the
spreadsheet further I am being warned of more compatibility issues. I need
to be able to use all the 2007 features to move forward so how do I convert
what I already have from 2003 to 2007? Is it as simple as changing the Save
As format to Macro Enabled Workbook? I don't want to re-create everything.
Thanks!


.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:54 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.