ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   EXCEL 2007 Worksheet expanding to maximum size unwanted (https://www.excelbanter.com/excel-worksheet-functions/196308-excel-2007-worksheet-expanding-maximum-size-unwanted.html)

GAMAP

EXCEL 2007 Worksheet expanding to maximum size unwanted
 
While working with Excel 2007, we have notice that intermitantly during row
insert and cut & paste function, the sheet auto-expands to maximum size
(column XFD and Row 105000000+). This causes the file size to be very large
and EXCEL starts giving warnings of "operation involving large amount of
data" during simple task. The only indication this has happened before a
save is the scroll bar shrinks down.

Has anyone seen this issue? Is there anything we can do to stop this from
happening?


All times are GMT +1. The time now is 01:43 PM.

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