Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can not copy a worksheet to another workbook
Hi,
I am currently using Excel 2003, I have a 3.11mb file with about 20 worksheets, this file has been around much longer than I have. Every month I would copy 4 worksheets to another workbook. This month I am no longer able to do this, I right click the tab, and choose move or copy, and choose the workbook, and check create a copy, nothing will happen, it does not matter if I right click on the worksheet tab or use the Edit menu. It will let me move the worksheet, but it will not allow me to copy it. I got an error message on named ranges (saying they already exist) when I moved it to a new workbook and then tried to copy it back to the orginal, I looked at the name ranges, and there had to be over 50 of them, I don't need them, so I deleted them all, expect one. it will not allow me to delete it, and it is refering to a workbook that no longer exist, before the name of the range it has to square boxes, I can not rename or deleted it, I dont know if this has anything to do with not being to copy the workbook. Please help if you can Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy the information from one workbook to another? | Excel Discussion (Misc queries) | |||
Copy tabs(sheets) from workbook without link to original source | Excel Discussion (Misc queries) | |||
Find a value in a workbook and return the worksheet name | Excel Discussion (Misc queries) | |||
copy data from one worksheet to identical sheet in different workbook | Excel Discussion (Misc queries) | |||
grand total column B from every worksheet in workbook | Excel Discussion (Misc queries) |