I have set up an formula to link data on one excel sheet to another
Ex.
='E:\New Folder\[MWellComposite_2.xls]Sheet6'!$C$11
This sheet (MWellComposite_2) is automatically generated from a data retrival system
When Sheet6 is not generated it is automatically named Sheet1.
='E:\New Folder\[MWellComposite_2.xls]Sheet1'!$C$11
Why does it loop back to Sheet1 & Can I stop it
Re: Links To Missing Sheets (help)
Hi gf,
I cn't replicate your problem but perhaps a macro to find/replace the reference?
Re: Links To Missing Sheets
I get the Error Worksheet Not Found. I want it to just show as Not Available but it shows it automatically goes to sheet 1. I have attached an example of this error. Is there a way to fix this.
Re: Links To Missing Sheets
gerardf,
I can't figure out what you need. Do you want to insert a new worksheet and have it named something besides Sheet1? Can you explain more clearly what you want and what problem you have in getting it?
Jim
Re: Links To Missing Sheets
gerard,
How about changing the link updating to manual?
Re: Links To Missing Sheets
I don't see any error in your screen shot! You are being very vague.
Don’t have an account yet? Register yourself now and be a part of our community!
