| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Workbook I want to convert to Excel 2007
This is probably real simple, and I feel like an idiot, but here goes . . .
I have an excel 2003 workbook template with macros that I open in excel 2007 and yet the columns are still 256 and rows are still only 16,000 or so rows viewing in excel 2007. How do I convert the 2003 workbook into 2007 so I can use the full enhancement of the number of rows and columns afforded by 2007 and still keep my macro template? Thanks -- paul |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 Workbook I want to convert to Excel 2007
I am only guessing at this point but have you tried saving the file in 2007
as a 2007 file and then closing and opening the file? HTH Otto "pglufkin" wrote in message ... This is probably real simple, and I feel like an idiot, but here goes . . . I have an excel 2003 workbook template with macros that I open in excel 2007 and yet the columns are still 256 and rows are still only 16,000 or so rows viewing in excel 2007. How do I convert the 2003 workbook into 2007 so I can use the full enhancement of the number of rows and columns afforded by 2007 and still keep my macro template? Thanks -- paul |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 Workbook I want to convert to Excel 2007
Open the template in Excel 2007. Save it as a macro enabled Excel 2007
template (.xltm). The template remains in compatibility mode until you close and reopen it. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "pglufkin" wrote in message ... This is probably real simple, and I feel like an idiot, but here goes . . . I have an excel 2003 workbook template with macros that I open in excel 2007 and yet the columns are still 256 and rows are still only 16,000 or so rows viewing in excel 2007. How do I convert the 2003 workbook into 2007 so I can use the full enhancement of the number of rows and columns afforded by 2007 and still keep my macro template? Thanks -- paul |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 Workbook I want to convert to Excel 2007
Thank you very much Jon . . . worked like a charm :)
-- paul "Jon Peltier" wrote: Open the template in Excel 2007. Save it as a macro enabled Excel 2007 template (.xltm). The template remains in compatibility mode until you close and reopen it. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "pglufkin" wrote in message ... This is probably real simple, and I feel like an idiot, but here goes . . . I have an excel 2003 workbook template with macros that I open in excel 2007 and yet the columns are still 256 and rows are still only 16,000 or so rows viewing in excel 2007. How do I convert the 2003 workbook into 2007 so I can use the full enhancement of the number of rows and columns afforded by 2007 and still keep my macro template? Thanks -- paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Open Workbook created in Excel 2003 in a computer that runs Excel | Excel Discussion (Misc queries) | |||
| Convert Excel 4 formula to Excel 2003 format | Excel Worksheet Functions | |||
| Sharing read-write Excel 2003 files | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Hybrid Mode
