johnny51981
Active Member
- Joined
- Jun 8, 2015
- Messages
- 409
I have 2 workbooks that I have linked together. One takes 2 massive csv files and makes them show ready for the second file.
I am currently working on cleaning these files up to make them quicker and cleaner, plus merging in some more from other files. However, when needing to make changes in the first file (in order of updating) that will be used in the second file, I can't save because having both open creates a sharing violation.
Is there a way to allow for both files to be open in a Writeable fashion and save work without causing a sharing violation, and without closing and reopening either file?
I am currently working on cleaning these files up to make them quicker and cleaner, plus merging in some more from other files. However, when needing to make changes in the first file (in order of updating) that will be used in the second file, I can't save because having both open creates a sharing violation.
Is there a way to allow for both files to be open in a Writeable fashion and save work without causing a sharing violation, and without closing and reopening either file?