Excel 2007 printing error: "The number must be between 10 and 400.

[Guest]

Hi,
An annoying error has started to surface in many (but by no means all) of my
worksheets when printing (some of the) charts. The print preview works fine
but then the error message "The number must be between 10 and 400. Try again
by entering a number in this range" appears. The graphs print fine when I
click the message away (although they then default to portrait printing
rather than landscape) but I cannot find any particular cause for this error.
Once it has occurred on a specific graph, it always occurs when printing that
graph but not necessarily when printing others. On one workbook, I copied
graphs from an alternative Excel 2007 workbook (and then changed the data to
refer to columns in the new workbook) and, although I do not get the errors
in the original Excel 2007 workbook (saved in Excel 2007 binary format) they
do persistently occur when printing from the new workbook (also Excel 2007
binary)!
Also, when I copied the graphs to the new workbook, I then edited the links
in the new workbook to remove any links to the original workbook but this did
not change the links for the graph data (perhaps because the graphs were
pasted in to a worksheet, not on separate chart sheets?)
Any ideas as to how to cure this error? There is a (restricted) hotfix for a
problem which gives the same strange error message but the scenario for the
cause of this message is somewhat different and I am not sure the fix would
be applicable to my instance (and I cannot easily download the hot fix as it
is not available on the Office updates page).
Many thanks, as always, and best wishes, Boris.

 

[Guest]

OK, seem (at least for the moment) to have got rid of the error - ny changing
the paper size in page setup for the graphs... Don't know what that's all
about but...

 

[Tampere]

I'm suffering of the exactly same problem as Boris, but haven't found a solution to it. Changing paper size doesn't work for me. Every time I try to print and this error pops-up (it doesn't happen every time), my printer also needs to be re-booted. Annoying.

Does anyone have some deeper knowledge? Would be highly appreciated!

Thanks in advance!
-J-

 

[hypercapnian]

Error printing charts in Excel 2007

I have the same problem, recently switched from Office 2003 to 2007 and am still trying to come to terms with the changes. I should explain that I am working with the German version of Office, hence some of the names found in Menus etc. may differ a little so please bear with me.

In the Excel options under Advanced, there is a setting for "automatic scaling". It is found under the Excel Options, by clicking on Advanced at the left, then scrolling almost all the way to the bottom in the right pane. I have a group titled "Allgemein" (German) or 'General', where there is a check box for selecting automatic scaling for A4 and Letter paper formats. I deselected this and the error during printing is now gone.

My only problem now is that I need to change the default printing mode for charts to landscape.

Hope it helps.

-H-