Impoting a worsheet into a workbook that has the same name

Topic

New Reply

I downloaded a workbook that I needed to update from our sharepoint site to my desktop. I made all the changes and added new charts as I needed. Now when I try to import that chnaged worksheet to my workbook I’m having a hard time because the 2 workbooks have the same name. I tried renaming my desktop workbook but it chnages all the links to the data in my charts and when I import it to the sharepoint spread sheet it gives me an error because it is looking for the desktop workbook. Is there a way to import the desktop worksheet to my sharepoint workbook if they have the same name? Thanks..

Reply | Quote

Replies

Why not replace the entire workbook?

Reply | Quote

can’t it’s a shared document and i don’t have control of it..

Reply | Quote