I have a workbook that is very very slow to open-its take about a minute to 
open.   With your folks help I have alot of VBA coding in this workbook.  
Also somehow a reference file or something like that as attached it self to 
this particular workbook, how do I remove that as well?

A person here at work suggested that I look at the personal.xls workbook, 
they couldn't remember how to find it, and I really have no clue.  Can 
somebody explain to me how to locate this book to see if this might be the 
problem?

Thanks

Steve

I should have said that the reference is referring to something called 
"FUNCRES.xla" not sure how it attached itself.

"caldog" wrote:

> I have a workbook that is very very slow to open-its take about a minute to 
> open.   With your folks help I have alot of VBA coding in this workbook.  
> Also somehow a reference file or something like that as attached it self to 
> this particular workbook, how do I remove that as well?
> 
> A person here at work suggested that I look at the personal.xls workbook, 
> they couldn't remember how to find it, and I really have no clue.  Can 
> somebody explain to me how to locate this book to see if this might be the 
> problem?
> 
> Thanks
> 
> Steve

Does it take a long time to open the workbook when Excel is already open or 
it takes along time for Excel to open?

Is the workbook on a network drive?  Maybe try saving the workbook locally 
and see if there is still a delay.

Maybe try:  Tools-Addins and uncheck Analysis Toolpak. Restart Excel.

Hope this helps!  If so, let me know, click 'YES" below.
-- 
Cheers,
Ryan


"caldog" wrote:

> I should have said that the reference is referring to something called 
> "FUNCRES.xla" not sure how it attached itself.
> 
> "caldog" wrote:
> 
> > I have a workbook that is very very slow to open-its take about a minute to 
> > open.   With your folks help I have alot of VBA coding in this workbook.  
> > Also somehow a reference file or something like that as attached it self to 
> > this particular workbook, how do I remove that as well?
> > 
> > A person here at work suggested that I look at the personal.xls workbook, 
> > they couldn't remember how to find it, and I really have no clue.  Can 
> > somebody explain to me how to locate this book to see if this might be the 
> > problem?
> > 
> > Thanks
> > 
> > Steve

Excel is already open when I try to open this workbook.  And the file is 
saved on my C drive.  Also another workbook was just slow to open, and it has 
NO VBA coding at all, just straight formulas and stuff.

"Ryan H" wrote:

> Does it take a long time to open the workbook when Excel is already open or 
> it takes along time for Excel to open?
> 
> Is the workbook on a network drive?  Maybe try saving the workbook locally 
> and see if there is still a delay.
> 
> Maybe try:  Tools-Addins and uncheck Analysis Toolpak. Restart Excel.
> 
> Hope this helps!  If so, let me know, click 'YES" below.
> -- 
> Cheers,
> Ryan
> 
> 
> "caldog" wrote:
> 
> > I should have said that the reference is referring to something called 
> > "FUNCRES.xla" not sure how it attached itself.
> > 
> > "caldog" wrote:
> > 
> > > I have a workbook that is very very slow to open-its take about a minute to 
> > > open.   With your folks help I have alot of VBA coding in this workbook.  
> > > Also somehow a reference file or something like that as attached it self to 
> > > this particular workbook, how do I remove that as well?
> > > 
> > > A person here at work suggested that I look at the personal.xls workbook, 
> > > they couldn't remember how to find it, and I really have no clue.  Can 
> > > somebody explain to me how to locate this book to see if this might be the 
> > > problem?
> > > 
> > > Thanks
> > > 
> > > Steve