error

[Guest]

Hi Guys

Any idea what the following informative message means that comes up every
time I open my workbook:

Cannot find XLQUERY.XLS!Register.DClick, which has benn assigned to run each
time [DocName.xls]RAG is opened. Continuing could cause errors. Cancel
opening [DocName.xls]RAG?

 

[Guest]

Hi,

if this happens only with specific workbook, you could have some macro or
VBA code in it that calls files that are not found.
But if you get the message everytime you start Excel with new (blank)
worksheet, there is probably some file in XLSTART folder that cannot find
file that is calling.
Default paths for XLSTART folders in Excel 2003 are:
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART
or in C:\Program Files\Microsoft Office\OFFICE11\XLSTART

If you find some files in xlstart and you do not have explanations why they
should be there (by default xlstart is empty), you should move them away, as
files in xlstart are opened automatically when you start excel.

Regards,
Nika Lampe

"Braindeadbeachbum" je napisal:

 

[Guest]

Hi Nika

I double checked but could not find any macro's in the default
"ThisWorkbook" or files in XLSTART. It only happens with the one file. What's
interesting is that if I change another sheet to be the default it would
replace RAG with the new default name within the message I receive.

It's not a train smash but this report does go to directors and the likes
and the only other option is to re-design this report with 20 worksheets and
alot of graphs and pivots... Not including the 300+ formulas. So, please...
If there's anything else that any one can think of.

Hi,

if this happens only with specific workbook, you could have some macro or
VBA code in it that calls files that are not found.
But if you get the message everytime you start Excel with new (blank)
worksheet, there is probably some file in XLSTART folder that cannot find
file that is calling.
Default paths for XLSTART folders in Excel 2003 are:
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART
or in C:\Program Files\Microsoft Office\OFFICE11\XLSTART

If you find some files in xlstart and you do not have explanations why they
should be there (by default xlstart is empty), you should move them away, as
files in xlstart are opened automatically when you start excel.

Regards,
Nika Lampe

"Braindeadbeachbum" je napisal:

Hi Guys

Any idea what the following informative message means that comes up every
time I open my workbook:

Cannot find XLQUERY.XLS!Register.DClick, which has benn assigned to run each
time [DocName.xls]RAG is opened. Continuing could cause errors. Cancel
opening [DocName.xls]RAG?