Could you try appending file1 to a newly created file2?
Excel sometimes remembers the working range in the sheet even if you deleted all contents. It is rather annoying, but most times it is solved by selecting entire worksheet and selecting Clear->Clear All, then saving and then reopening the file.
But to be sure if that is the case in your situation, I would first try to append your data from the first file to an empty, newly created second file.
Excel sometimes remembers the working range in the sheet even if you
deleted all >contents. It is rather annoying, but most times it is solved by >selecting entire >worksheet and selecting Clear->Clear All, then saving
and then reopening the file.
Great!! I wanted above information!!
BTW, I haven’t tried it with new file, so I’ll try soon.