Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Macros compatibilty with earlier versions!!
Are macros in Excel 2007 compatible with Excel 2003?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Macros compatibilty with earlier versions!!
Well, as long as you don't use any XL2007-specific features then you
should be okay. So, don't use more than 256 columns or 65536 rows, don't use SUMIFS or COUNTIFS, don't use conditional formatting with more than 3 conditions, don't use xlsx/xlsm filenames, don't use full-column references in SUMPRODUCT or array formulae ... etc. It might be safer to develop the macros in XL2003 and then use them in XL2007. Hope this helps. Pete On May 8, 12:50*pm, Raja wrote: Are macros in Excel 2007 compatible with Excel 2003? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving charts in Excel 2007 so compatible with earlier versions | Charts and Charting in Excel | |||
Excel 2007 won't open earlier versions | Excel Discussion (Misc queries) | |||
Are XL 2007 charts readable with earlier versions ? | Charts and Charting in Excel | |||
Is it possible to convert Excel 2007 files to earlier versions? | Excel Discussion (Misc queries) | |||
List function in earlier Excel versions | Excel Discussion (Misc queries) |