Báo lỗi the number must be between 10 and 400 năm 2024
|
Posted to microsoft.public.excel.misc external usenet poster 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. Posted to microsoft.public.excel.misc external usenet poster 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... "Boris" wrote: 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. Worksheets can get very big, very fast. Often you want to still print an entire worksheet in a single sheet of paper. Excel makes this easy to do by using scaling. All you need to do is follow these steps:
Figure 1. The Page tab of the Page Setup dialog box.
One of the tricks I often use is to set the Fit To settings to 1 page wide by 99 pages tall. In this way, I am sure the output will fit on one page across. Since my output isn't over 99 pages in length, no shrinking is done on this dimension. I end up with output that is 1 page wide by how ever many pages long Excel needs to print. ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2841) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Scaling Your Printing. Author BioWith more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. Learn more about Allen... MORE FROM ALLENMoving Subtotals When you add subtotals to a worksheet, Excel typically places them in the same column that you are subtotaling. If you ... Discover More Adding Diagonal Borders Borders on all sides of a cell are easy to do in Excel. You can also create diagonal borders that run right through the ... Discover More Converting Text Inside Double Asterisks to Bold In plain-text documents, it is not uncommon to see asterisks used around text to indicate what should be considered bold ... Discover More More ExcelTips (menu)Resetting Page Setup If you ever open a workbook and find that your carefully crafted worksheets no longer print on the number of pages you ... Discover More Defining a Custom Paper Size Need to print your worksheet on a non-standard paper size? Excel is rather limited in printing to such papers, and here ... Discover More Setting Page Margins When getting ready to print your worksheet, you may want to take a moment to check what margins Excel will use on the ... |
