Change your default Save format to a 2007 format
When you insert a new workbook it have more the 65 k lines

Office Buttonexcel Options...Save
You can change it there

You can always use SaveAs to save a 97-2003 format or let the people in the Office install the
2007 Compatibility Pack
http://www.rondebruin.nl/2007filesin2003.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Rick" wrote in message ...
Hi,

I have a couple of general questions 2007.

Firstly because I am th eonly on in the office with 2007 I have to operate
in compatibility mode so I save all files as 2003 so others can use the
files. I want to start a 2007 file with more than 65k lines but I can't seem
to do it. The only way I can do it is to open an existing 2007 file add a tab
and then move this tab to a new book. Not very efficient. How can I create a
new 2007 without having to open an existing one. Can you turn off
compatibility Mode?

The 2nd is relating to Pivot tables.

In 2003 you could select mutiple sources. How do you do this in 2007?

Thanks
Rick