Free Support Forum -

Excel error when freezing one row using freezePanes()

I am trying to freeze the first row (headers) and get an excel error when I open the file: "File Error: Data may have been lost". (No data was actually lost.) After the error, the first row is frozen, but the I can only scroll using the scrollbar (wheel doesn't work).

I used wks.freezePanes(1, 0, 1, 0); to freeze the first row only and no columns. If I use (1,1,1,1) to freeze the first row AND the first column everything works great, so I guess it just doesn't like zeroes...

Also, thanks for the amazing customer support!


Please the fix in