View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rick Rick is offline
external usenet poster
 
Posts: 334
Default Excel 2007 questions

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