Got a bug recently on a 36MB workbook with lots of hours in it. HE

  • Thread starter Thread starter Bruno
  • Start date Start date
B

Bruno

I there.

Most my of my links redirect to the correct row or sheet, most are graphs,
but then it shows an error message saying something like this (original
version in portuguese): "No more letter formats will be allowed on this
workbook" with the option OK.
I can close or chose OK but will get the same window time after time, and
then my EXCEL gets frozen and I can't save my document or close excel, I then
have to kill the process.

I have two types of links:
Direct hyperlinks to cell x

and a more dynamic link because the cells are always moving and I had to
create a counter on a reference cell
=HYPERLINK("#"&CÉL("content",RO!D3007), "90") [don't know if these are the
correct function calls in english due to translation but it's easy to
understand to anyone who uses functions]

I've searched and I don't see anything close to this, or my base translation
is wrong, no file size limits or format limits are known in Excel.
I have 43 sheets with the longest having 3900 rows, medium columns per sheet
12.
I have lots of conditional formating but removing doesn't solve it as
removing other types of formats, saving and then click the links gets to the
same.

I've written bigger workbooks and they are working ok, also tried copying
all the sheets to another file.... NADA WORKS!!


Is there any expert on this bug??

I use Excel 2003 SP3
Windows XP Home edition SP3 1GB of RAM 2.66 Dualcore Int processor
 
Excel does have a limit to the number of formats that can exist in one
workbook. It sounds like you hit that limit. I'm afraid I don't have
experience 'recovering' a workbook that has already hit that limit, so I
can't provide any tips- here is the MS KB article, but it just says to reduce
the number of formats, and it sounds like you've already tried that.

http://support.microsoft.com/kb/213904

In the back of my brain, I'm thinking that this applys not only to cell
formats, but the text format in graphs as well- so if you have a lot of
graphs, try to standardize them as well.

Here is another thought- what is the maximum number of graphs you have on
any given worksheet? I seem to recall there was a maximum number of graphs,
and that might throw an error that wasn't intuitive (can't recall if it was
this one or not).

Best,
Keith
 
Back
Top