Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MS Excel 2007 Pivot Table Question

Posted on 2011-03-20
4
Medium Priority
?
192 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 (Microsoft MVP / EE MVE) earned 1000 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
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 1000 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

927 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