Solved

MS Excel 2007 Pivot Table Question

Posted on 2011-03-20
4
185 Views
Last Modified: 2012-05-11
As I spend most of my time buried in databases I rarely use Excel. I have two questions.

I have an Excel spreadhseet containing four rows of data but each row consists of about 85 columns. I would like to switch the rows to the columns and the columns to the rows. Is there a basic tutorial on how to do this?

Also, every time I open this spreadsheet it keeps telling me certain options have been disabled and I then click on the Options button to enable them. After saving the spreadsheet and reopening it asks the same damn fool question again. How do I stop that?
0
Comment
Question by:rwheeler23
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 250 total points
ID: 35177586
Hello,

First question: You can copy the data, then click in a new sheet in A1 and use Paste Special and tick the Transpose option.

Second question: Which options are these?

cheers, teylyn
0
 

Author Comment

by:rwheeler23
ID: 35177770
Data Options. It talks about somethng called Trust Center. Microsoft Office Security Center.
0
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 35177855
That sounds like a completely different issue. I don't run 2007. Some aspects of 2007 are quite buggy. You may want to start a new question with a title that reflects the problem to draw experts who know about it.

cheers, teylyn
0
 
LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 250 total points
ID: 35178469
You need to click the Office button (top left) then Excel Options, then look at the Trust Center settings. Which ones depends on which specific messages you are getting.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question