I click the radio button for landscape and nothing changes. The display is
portrate, as is the printout. How do I get it to print landscape?

Excel 2007
The error is related to the position of the blank cells.
I did not find a solution or workaround.
Here is your example stripped to the essentials:
http://www.mediafire.com/file/nzuyidmwzlz/BadMax.xlsx

Hi Cheryl,

Check in Tools, Options, general, see if a path is mentioned in "At startup,
open all files in:". If so, clear that entry.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

I have Hyperion/Essbase on my computer in Excel. I keep getting the Essbase
error message "You do not have sufficient access to perform a lock on this
database". I have uninstalled and re-installed Hyperion/Essbase multiple
times on my computer and I can not get the error message to stop. It has
gotten so bad that I can not pull anything from Essbase. Please let me know
any ideas that can help me. Thank you

Hi everyone and thanks in advance for any help you can offer. It seems I can
always find someone on here with the answer I need.

I am using XP Pro and Office 2007.

I'm not sure how to describe my problem, but here goes:

I have built a template and saved it as an .xlts file. It appears in the "My
Templates" box when I ask for it. The template has three or four colums for
dates, a couple of columns for amounts (currency) and some general columns. I
have formatted all cells appropriate for their type of data. Additionally, I
hav a couple of columns that are filled with color full length as they define
some borders. I use a separate page for each customer's information.

If I open the template as a new workbook it opens OK and everything is as I
have saved it as a template.

However (here's the problem), when I attempt to insert the template page
into an existing workbook the page will insert and open OK, but a lot of the
formatting is missing or has mysteriously been replaced by formatting I
didn't select and don't want. Some of the columns that have color fill will
only be partially filled with some cells left white. I had formatted all date
cells as xx/xx/xx, but many of them are now formatted as x/xx/xxxx.

Hi everyone and thanks in advance for any help you can offer. It seems I can
always find someone on here with the answer I need.

I am using XP Pro and Office 2007.

I'm not sure how to describe my problem, but here goes:

I have built a template and saved it as an .xlts file. It appears in the "My
Templates" box when I ask for it. The template has three or four colums for
dates, a couple of columns for amounts (currency) and some general columns. I
have formatted all cells appropriate for their type of data. Additionally, I
hav a couple of columns that are filled with color full length as they define
some borders. I use a separate page for each customer's information.

If I open the template as a new workbook it opens OK and everything is as I
have saved it as a template.

However (here's the problem), when I attempt to insert the template page
into an existing workbook the page will insert and open OK, but a lot of the
formatting is missing or has mysteriously been replaced by formatting I
didn't select and don't want. Some of the columns that have color fill will
only be partially filled with some cells left white. I had formatted all date
cells as xx/xx/xx, but many of them are now formatted as x/xx/xxxx.

I have a large spreadsheet with 6 tabs each with up to 100 columns and 1000
rows. I am able to create and use a list style data validation, but when I
save the file and reopen it, the validation is gone. I can create a new
(blank) spreadsheet that uses data validation and it saves and opens
properly.
I am guessing this is due to a limitation of either the Home & Student
version that I have or due to the fact that it is a trial, or due to new
limitations in Excel07 (it worked in Excel03 in the same spreadsheet).
Can anyone say which it is. I don't want to buy the student version and
then still have it not work, but I don't want to buy the Pro version if it is
not needed or still will not work.

I have 2 if statements that I am trying to combine into one formula. What is
the correct sequence for these to work?