![]() |
Strange Excel error
Hi all, I use Excel 2007 to construct a weekly schedule for where I
work. The template was passed onto me from a prior coworker, so I'm not sure what can cause this. Basically the workbook contains 3 sheets. The first is the schedule itself, in which each day is represented by a chart and a title. The chart contains our employees' names at the left, with the time in 30-minute intervals at the top. We designate time they're supposed to be here by placing an X on the schedule under the corresponding times. All of these cells use a "general" cell format (not 'numbers' or 'time' or anything else). The problem I have is this. I recently have developed the need to place more than one character in a box at a time. However, whenever I attempt this (either by a 2-letter combination like XS, or numerical value greater than 9), I get the following error: "Due to the new database, you can only have one character in a time block." Does anyone have any idea what might cause this? Thanks in advance for any advice. -Adam |
Strange Excel error
On Fri, 17 Aug 2007 11:49:14 -0700, D23 wrote:
Hi all, I use Excel 2007 to construct a weekly schedule for where I work. The template was passed onto me from a prior coworker, so I'm not sure what can cause this. Basically the workbook contains 3 sheets. The first is the schedule itself, in which each day is represented by a chart and a title. The chart contains our employees' names at the left, with the time in 30-minute intervals at the top. We designate time they're supposed to be here by placing an X on the schedule under the corresponding times. All of these cells use a "general" cell format (not 'numbers' or 'time' or anything else). The problem I have is this. I recently have developed the need to place more than one character in a box at a time. However, whenever I attempt this (either by a 2-letter combination like XS, or numerical value greater than 9), I get the following error: "Due to the new database, you can only have one character in a time block." Does anyone have any idea what might cause this? Thanks in advance for any advice. -Adam Data/Validation --ron |
Strange Excel error
On Aug 17, 3:04 pm, Ron Rosenfeld wrote:
On Fri, 17 Aug 2007 11:49:14 -0700, D23 wrote: Hi all, I use Excel 2007 to construct a weekly schedule for where I work. The template was passed onto me from a prior coworker, so I'm not sure what can cause this. Basically the workbook contains 3 sheets. The first is the schedule itself, in which each day is represented by a chart and a title. The chart contains our employees' names at the left, with the time in 30-minute intervals at the top. We designate time they're supposed to be here by placing an X on the schedule under the corresponding times. All of these cells use a "general" cell format (not 'numbers' or 'time' or anything else). The problem I have is this. I recently have developed the need to place more than one character in a box at a time. However, whenever I attempt this (either by a 2-letter combination like XS, or numerical value greater than 9), I get the following error: "Due to the new database, you can only have one character in a time block." Does anyone have any idea what might cause this? Thanks in advance for any advice. -Adam Data/Validation --ron Muchas gracias! You saved my lunch hour =) -Adam |
Strange Excel error
On Fri, 17 Aug 2007 12:22:34 -0700, D23 wrote:
On Aug 17, 3:04 pm, Ron Rosenfeld wrote: On Fri, 17 Aug 2007 11:49:14 -0700, D23 wrote: Hi all, I use Excel 2007 to construct a weekly schedule for where I work. The template was passed onto me from a prior coworker, so I'm not sure what can cause this. Basically the workbook contains 3 sheets. The first is the schedule itself, in which each day is represented by a chart and a title. The chart contains our employees' names at the left, with the time in 30-minute intervals at the top. We designate time they're supposed to be here by placing an X on the schedule under the corresponding times. All of these cells use a "general" cell format (not 'numbers' or 'time' or anything else). The problem I have is this. I recently have developed the need to place more than one character in a box at a time. However, whenever I attempt this (either by a 2-letter combination like XS, or numerical value greater than 9), I get the following error: "Due to the new database, you can only have one character in a time block." Does anyone have any idea what might cause this? Thanks in advance for any advice. -Adam Data/Validation --ron Muchas gracias! You saved my lunch hour =) -Adam no es nada --ron |
All times are GMT +1. The time now is 02:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com