Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Why are my page layout options grayed out?

I am new to the 2007 version and cannot figure out why MARGINS, ORIENTATION,
and SIZE are grayed out under the Page Layout tab. I have tried copying and
pasting to new workbook but still not working. Any suggestions?


Post your answer or comment

comments powered by Disqus
Why are my row numbers/column letters struck through?

I've been learning PivotTables recently and I'm just beginning Performing PivotTable Calculations. I'm trying to change the PivotTable Summary Calculation. I'm following my book's instructions step-by-step and all the pictures are the same, until my problem. All my Summarize By: options are grayed out (i.e. Sum, Count, Average, Max, Min, etc.)

Using Excel 2003

Here's what I'm doing:
Right-click on data field button
Choose Field Settings
Then I'm supposed to be able to select the summary calculation I want, but I can't. All the options are grayed out.

I've tried toggling everything I can find to toggle and nothing is working. Any ideas what would cause these to be greyed out? Is it a problem with my source data? Thanks for any help.

My Excel 2003 question is the following on an unprotected workbook.

1. Why would the following toolbars be GRAYED OUT on a spreadsheet with tons
of formulas.
Tools:Formula Auditing: TRACE PRECEDENTS, TRACE DEPENDENTS, TRACE ERROR,
REMOVE ALL ERRORS.

2.) When I click on Tools Options General, and under Objects click on SHOW
ALL I get a skinny vertical scroll bar that I cannot close nor can I do
anything with it. It does blink though if I click on the bar in the middle. I
cannot move it anywhere either.

THanks for any help.
Michele

This is in a workbook it was password protected and able to be unlocked, now
when trying to unprotect it the option to unprotect is grayed out 3 other
clients are using this workbook and the option is grayed out for them as
well.
One day it was fine the next day they couldnt access it.

I have a shared workbook. Once in a while, I cannot uncheck the allow
changes by more than one user at the same time. This option in the shared
workbook under the tools menu is grayed out. Other times this option is
available. Can someone please tell me why this option becomes unavailable.

hi again,

i am trying to set the page layout option when i cliack a 'print' button on my form.

at the moment it makes a selection on a sheet and prints that selection. i want it to fit to screen and be landscape as well as include column titles.

for some reason the landscape request is working but the fit to screen doesn't.
also, the column title are returned as 'a,b,c,d,e...etc' instead of my actual column titles.

here's what i've got already......

With ActiveSheet.PageSetup
                    .PrintTitleColumns = "$A:$K"
                    .Orientation = xlLandscape
                    .FitToPagesWide = 1
                    .FitToPagesTall = 1
                    End With
                    Selection.PrintOut Copies:=1, Collate:=True

can anyone help...pleeeease.

thanks,
spinkung.

Why is the merge cells function grayed out in a shared workbook? Anyone got a
fix?

Hello,
i need help locking header and footer as well as page layout options..

I need to password protect or something along that like to do with above mentioned functions for my application...

I am using 2007 and 2003 excel...

Please if any one can help me solve it...

For some reason, in the Options window, under the General tab, the option of having a recently used file list is grayed out. It's a minor thing thing, but annoying. This is a business machine which already had MS Office installed.

Using Windows XP and Office 2002. Any help would be appreciated. Thanks.

I can see import but export, map properties and refresh data are grayed out. Suggestions?

I go into print preview, and the "zoom" button is grayed out. The only way
it appears is if I go into "help" and get a generic description of print
preview. When I close the help screen, the zoom button returns to being
grayed out.

Why are some of my excel files colored blue and some are in black? This
occurred after an IT tech servicing was done>

When I try to set the top row of my spreadsheet, to Print Titles section is
grayed out.

Hello Everyone,

I have some formulas in a destination workbook that reference data in a source workbook.

QUESTION 1:

I would like to disable the automatic update of these links, and instead require the update process to be triggered manually. But the manual radio button in the Edit Links window of the destination workbook is grayed out. What to do?

QUESTION 2:

As you might infer from the first question, the update process for these links is currently set (stuck) to automatic. My understanding is that all cells in the destination workbook with external references to the source workbook should not be automatically updated or otherwise recalculated, unless and until the source workbook is opened. However, I seem to be experiencing a different behavior. For example, I created a column in the destination workbook populated with versions of this formula:

=IFERROR(IF(LEN(INDEX('AssocExecs master 3.5.xlsx'!Table1[#Data],MATCH(G12,'AssocExecs master 3.5.xlsx'!Table1[[ ORGANIZATION]],0),4))>0,"Yes","Error"),"No")

When the destination workbook is first opened, with the source workbook closed, the destination workbook shows a mix of "Yes" and "No" values, representing the last correct values when both workbooks were simultaneously open.

However, without ever opening the source workbook, the values returned by these formulas will all change to "No" after a few minutes (or some unrecognized event).

What might be happening?

Cheers,

Jay

Sample sheet attached. Basically, I want to know why averaging my averages is not coming to the correct number. I have a data set that calculates an average. I am then averaging the averages of that data. Each row on the sheet holds the same weight of the total. I then turn around and add up the total data and average that to get the average of the averages, and the number is different. I have set the decimal places all the same.

Why are some of my excel files colored blue and some are in black? This
occurred after an IT tech servicing was done>

I would like to change my page layout so that every time I open a new excel
sheet it is landscape form rather than portrait. Can this be done? how?

Hello,
I want to restrict people from changing several page layout options mentioned bellow.

Print scale
Header and Footer
Headings

Please if any one can help me to do so.

Thank you

i'm new to microsoft office and i need help with excel 2007, i'm trying to
change my margins to fit the page and rotate the orientation to landscape,
but everytime i go into page layout tab, the those two buttons are grayed
out. i can't change these settings, i tried opening a new workbook and i
still can't change these settings,what am i doing wrong??

I can't print titles on my Excel sheets. The "Print Titles" option is grayed
out and I can't figure out why. I am running Excel 2003. What am I doing
wrong?

I'm having trouble with several of my menu options being grayed out in Excel
2003. When I have a blank workbook option, several options are not available
to me: options, security, protection, macros, formula auditing, inserting
rows, columns, pictures, etc. However, if I sign into my husband's user
account, those options are all available to me. My profile is assigned as an
administrator, so I should have full accesss. The odd thing is that this is
only doing this in Excel and no other office programs.

My company gives us Excel docs with macros to report our financials. My main
frustration is that I don't have the option to change my security levels to
enable macros under my profile using Excel. I have the option to enable
macros under my husband's profile when I sign into his.

Any ideas?

I'm having trouble with several of my menu options being grayed out in Excel
2003. When I have a blank workbook option, several options are not available
to me: options, security, protection, macros, formula auditing, inserting
rows, columns, pictures, etc. However, if I sign into my husband's user
account, those options are all available to me. My profile is assigned as an
administrator, so I should have full accesss. The odd thing is that this is
only doing this in Excel and no other office programs.

My company gives us Excel docs with macros to report our financials. My main
frustration is that I don't have the option to change my security levels to
enable macros under my profile using Excel. I have the option to enable
macros under my husband's profile when I sign into his.

Any ideas?

I can't print titles on my Excel sheets. The "Print Titles" option is grayed
out and I can't figure out why. I am running Excel 2003. What am I doing
wrong?

I tried to use Excel (2007) today and got a surprise: I can't enter data into any cell. When I try to, it acts like I'm not typing at all, and nothing happens. This is when I enter data directly into a cell, or into the formula fx bar.

I checked the "office button" menu, and all the options are grayed out except "Print, Open, and Close", so I can't save or start a new file. When I try to change the "Excel Options" under the button in the same menu, it won't let me click on any of the tabs in the window that comes up, the only tab it will let me see is the "resources" tab. Again, it just acts like I'm doing nothing. Also, almost all the options on all the ribbon menus are grayed out. All the options that do something useful, I can't use. I can't do anything in Excel at all, except open and view files.

My mouse and keyboard work, i checked that first. I tried restarting my computer, restarting Excel, opening several worksheets, and have the same problem. I ran a "Microsoft Office Diagnostic" from that Resources tab, but it said "no problems found". I looked for some solutions online, but no luck. I can't "re-install" Excel because it came with this computer, I don't have a disc to reinstall from. I'll check for viruses later when I get home, but I really don't think that's the problem.

Any ideas? Thanks for your help.


No luck finding an answer? You could always try Google.