I am not brilliant on Excel, and I cannot find a solution to my latest problem.
I have workbooks with formatted worksheets, and want to copy the formats/formulas from one workbook to another. I normally do this using copy/paste & copy/paste special/formulas.
Now, when I copy from one workbook, then select Paste Special in the destination workbook, I don't get the normal 'paste special' window which allows selection of formula/format/value/transpose, etc. What I get now is a window that says 'Paste Special', then gives the location of the source file and then an option of Paste or Paste Link. It contains a drop down selection of filetypes!
I have searched through the helpfiles but haven't found anything helpful. Any clues anyone?
Replies (5)
Please login or register to join the discussion.
Viewing spreadsheets side by side
Shirley - Can you use the Excel "View Side by Side" button in Excel to view the two spreadsheeets at the same time? Or have I misunderstood the problem?