pivot tables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables

Pivot tables

resolvedResolved · High Priority · Version 2007

Adrian has attended:
Excel Advanced course

Pivot tables

How to create pivot tables of airline schedule info. (using multiple consolidation ranges and text to columns), where arrival/departure time reflects original data (whereas it now formats as a decimal point eg. 0.000123)

RE: Pivot tables

Hi Adrian

Thank you for your question

It is difficult to advise you without seeing the spreadsheet in question. Could you email a copy of the workbook to me at stephen@stl-training.co.uk and I will investigate and reply

Regards

Stephen

RE: Pivot tables

Hi Adrian,

Did you manage to get a copy of your workbook to Stephen?

This question has now been left unattended for a while.

We like to keep down the large number of active forum posts we receive.

As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).

We look forward to hearing from you.

Thank you.
Regards, Rich

RE: Pivot tables

Hi Rich,

Sorry - meant to send it earlier. Which file do you want to have a look at - the Mr. Excel one or my own? Please advise.

Adrian.

RE: Pivot tables

Hi Adrian

If you could send me a copy of both files, I will endevour to solve the issue for you

Regards

Stephen


 

Excel tip:

Change the default location for opening and saving spreadsheets

If you are always opening spreadsheets from and/or saving documents to a specific location that is not My Documents, save time by setting this folder as the default for opening files from and saving files to.

Here's how:
1. Go to Tools - Options.

2. Select the General tab.

3. Enter the pathname of the folder you wish to make the default in the Default File Location box (hint: it will be easier to use Windows Explorer to navigate to this folder, then copy and paste the pathname from the address bar at the top of the Windows Explorer screen).

4. Click OK.

You have now changed the default folder for opening and saving spreadsheets.

View all Excel hints and tips


Server loaded in 0.11 secs.