Reply to thread

Message: [QUOTE="Guest, post: 10541253"] I don't know if you'd call this a solution but I think I found a way to circumvent the problem. The file I was getting Name Conflict "Print_Area" error for had multiple worksheets, all of which had been formatted to print only a certain portion of the worksheet. I opened the file in an older version of Excel and on each worksheet, I reset the print area. I was then able to open the file in Excel 07. An interesting thing about this process is that when I opened the newly reset file in Excel 07, the original print areas were still intact. This may be a quirk with my individual file or it may be a function of the coding. I don't know. All I know is that I can now open this necessary file in Excel 07. It also makes me think that the macro idea from Ron might be the way to go---set a macro to reset the print areas in your files. Hope this helps. Michael [/QUOTE]