ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel wants to create a page break in every cell! (https://www.excelbanter.com/excel-discussion-misc-queries/261329-excel-wants-create-page-break-every-cell.html)

Frustrated analyst

Excel wants to create a page break in every cell!
 
After saving revisions in an Excel worksheet, I get a popup message that
states "Margins do not fit page size". After clicking "ok" (because this is
my only choice) a page break is automatically created in ever cell. At
times(depending on the sizeof the work sheet) it can be over 100 pages with a
page size 14% or smaller.

Why does this happen, and how can I avoid it?

Dave Peterson

Excel wants to create a page break in every cell!
 
I saw this suggestion in a different forum.

Try closing excel.
Clean up your windows temp folder
Windows start button|Run
type:
%temp%
and hit enter

Clean all those files that you can. (You may have some files in use, so skip
those.)

Then try your workbook again.

Please post back with your results -- good or bad.

Thanks.

Frustrated analyst wrote:

After saving revisions in an Excel worksheet, I get a popup message that
states "Margins do not fit page size". After clicking "ok" (because this is
my only choice) a page break is automatically created in ever cell. At
times(depending on the sizeof the work sheet) it can be over 100 pages with a
page size 14% or smaller.

Why does this happen, and how can I avoid it?


--

Dave Peterson


All times are GMT +1. The time now is 02:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com