View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Janet Lyn Janet Lyn is offline
external usenet poster
 
Posts: 2
Default Row Height Keeps Changing

I have a spreadsheet in a workbook. To the right of the spreadsheet is a
pivot table summing up all the data on the spreadsheet. The problem is my row
heights on the spreadsheet are manually set at 18. However, when I open the
workbook, it changes the row heights of the first 10 cells, which are the
cells made by the pivot table, making them too small to be able to read the
data in the spreadsheet. As the month gets longer and more data for the month
is entered into the spreadsheet, the pivot table will get to be much longer
and then all the lines on the spreadsheet will be much smaller than I want.

I have tried everything to keep the rows the height of 18, and nothing
works. I have been unable to find a person with this 2007 problem online so I
would appreciate any help I can get to this problem.

Thanks, JL