<div>
Data Options. It talks about somethng called Trust Center. Microsoft Office Security Center.
</div>


Data Options. It talks about somethng called Trust Center. Microsoft Office Security Center.

<div>
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.<br />
<br />
cheers, teylyn
</div>


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

<div>
<div class="content wysiwyg-content">
As I spend most of my time buried in databases I rarely use Excel. I have two questions.<br />
<br />
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?<br />
<br />
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?
</div>
</div>


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?

MS Excel 2007 Pivot Table Question

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.