Hi,
I'm getting an error message when I try to insert a column in the spreadsheet. There are 3 worksheets in the workbook. Each spreadsheet represents a sales rep. A list
of businesses companies is in column A. Each week Column B is highlighted, a column is inserted to add that week's point totals to the spreadsheet; therefore, column B has the most current week with columns C, D, ....
having the previous weeks points.
When I went in and highlighted column B to insert a column, I got an error message. It read, "To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet. Try to delete or clear the cells to the right and below your data. Then select cell A1, and save your workbook to reset the last cell used. Or you can move the data to a new location and try again."
I cannot insert columns anywhere at all, but oddly enough the last worksheet in the workbook will let me insert. As of now, the worksheet only goes up to column F and I'm only using 40 rows so it's not a large worksheet.
How can I get the ability to insert columns back?
Your help would be greatly appreciated.
Ann
I'm getting an error message when I try to insert a column in the spreadsheet. There are 3 worksheets in the workbook. Each spreadsheet represents a sales rep. A list
of businesses companies is in column A. Each week Column B is highlighted, a column is inserted to add that week's point totals to the spreadsheet; therefore, column B has the most current week with columns C, D, ....
having the previous weeks points.
When I went in and highlighted column B to insert a column, I got an error message. It read, "To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet. Try to delete or clear the cells to the right and below your data. Then select cell A1, and save your workbook to reset the last cell used. Or you can move the data to a new location and try again."
I cannot insert columns anywhere at all, but oddly enough the last worksheet in the workbook will let me insert. As of now, the worksheet only goes up to column F and I'm only using 40 rows so it's not a large worksheet.
How can I get the ability to insert columns back?
Your help would be greatly appreciated.
Ann