ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Splitting Linked Files (https://www.excelbanter.com/excel-discussion-misc-queries/34232-splitting-linked-files.html)

Sparky

Splitting Linked Files
 
I have 3 files used for materials management. They each contain data
crosslinked from file to file. The files have become quite large and editing
each is being impaired due to the size of the files.

Will splitting the files into several smaller files improve performance? The
links would still remain but each file would have a maximum of 25 or so
worksheets nstead of the 200 currently in the largest of the 3. Any input is
appreciated.
--
Like a duck on a pond, stay calm on top and paddle like hell underneath.


All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com