• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

MS Excel 2007 Pivot Table Question

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
rwheeler23
Asked:
rwheeler23
  • 2
2 Solutions
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
rwheeler23Author Commented:
Data Options. It talks about somethng called Trust Center. Microsoft Office Security Center.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
Rory ArchibaldCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now