Quote:
Originally Posted by CellShocked
On Wed, 29 May 2013 10:35:59 +0100, SinghNZ
wrote:
Is there a simple way to work around this?
Come up with a better paradigm for performing the data archiving task
you think this accomplishes.
It is like you are setting up all these interdependent links as an
exercise, as no professional would set up such an array to store critical
accounting data. It has too many vulnerabilities.
It would seem the location for a lot of the worksheets would best be on
the same sheet, instead of keeping them separate, thereby solving many of
the problems your concept has created.
|
Hi
Thanks for your suggestions. I am a novice. I have my own reasons for doing this way, may be not efficient in the eyes of a professional.
(Vulnerabilities) Each worksheet will have data in about 400 to 500 rows. Having this amount of data on each worksheet, and all worksheets in one workbook, in my humble view, opens up another grave vulnerability - corruption of data. I am trying to create separate individual worksheets to avoid post data corrupt scenario. Should this to occur, only that particular sheet will get corrupted and unusable, and not the entire data in all the worksheets. This is the sole reason for creating individual worksheets.
(It would seem the location for a lot of the worksheets would best be on the same sheet, instead of keeping them separate, thereby solving many of the problems your concept has created.) - I would love to go your way as suggested if this can save me all the effort of manually entering path for each connection. My only worry is, I reiterate, post data corruption scenario. Do I assume correctly that creating a back up file could be the simple solution for post data corruption scenario? If so, I will need to learn how to extract / use data from the back up file, (in the case of data corruption in the main file) and make my main workbook working again.
Regards
Similar Threads
Threaded Mode
