📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Spreadsheet help needed.

2»

Comments

  • f1charlie wrote: »
    Pivot tables are in 2003 and you can also produce pivot charts from them.

    And I don't know about you but every time I produce a pivot in .xlsx (usually daily), the first thing I do is change it to display in 2003 format!
    "We can all fly as high as the dreams we dare to live...........unless we are a chicken" ~ Anon.
  • f1charlie
    f1charlie Posts: 1,228 Forumite
    I guess you mean the 'Classic Pivot Table layout' :). Yes I change that, although I find the field list layout better and easier to use.
    But I wish they had allowed you to set the default field settings subtotals, as I've always got to go in and change it to 'None'. Unless they have and I've missed it!

    Ooo-err this is all getting a bit geeky!
    Charlie
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 356K Banking & Borrowing
  • 255K Reduce Debt & Boost Income
  • 456.3K Spending & Discounts
  • 248.5K Work, Benefits & Business
  • 606.2K Mortgages, Homes & Bills
  • 179.1K Life & Family
  • 264K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.7K Read-Only Boards
Quick Search

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.