ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Strange Excel error (https://www.excelbanter.com/excel-discussion-misc-queries/154750-strange-excel-error.html)

D23

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


Ron Rosenfeld

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

D23

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


Ron Rosenfeld

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