Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel: Copy & Paste Issue

  • 27-03-2008 2:49pm
    #1
    Cork Skate
    Registered Users, Registered Users 2 Posts: 884 ✭✭✭


    Hi there,

    I have a problem copying and pasting in Excel from one workbook to another.

    When i go to copy a full sheet to another workbook, sometimes when i copy i get an error message saying that i can only copy 255 characters from any one cell during to action. And it then goes and removes everything for the 256the character and onwards from every cell that had 255+ characters.

    Copying cells on their own is fine but i cant do this for everything. Does anyone know a way around this, or can i increase the number of characters even?


Comments

  • #2
    irlrobins
    Registered Users, Registered Users 2 Posts: 7,541 ✭✭✭irlrobins


    Open the workbook you want to copy from
    Open a new blank workbook you want to copy to
    Right click on the tab you want to copy and choose Move/Copy Sheet.
    Select the new blank workbook you want to copy it to and tick the "Make a copy" box

    That should work.


  • #3
    Cork Skate
    Registered Users, Registered Users 2 Posts: 884 ✭✭✭Cork Skate


    irlrobins wrote: »
    Open the workbook you want to copy from
    Open a new blank workbook you want to copy to
    Right click on the tab you want to copy and choose Move/Copy Sheet.
    Select the new blank workbook you want to copy it to and tick the "Make a copy" box

    That should work.

    Nah, still the same. Its says that that is the answer in a few places on Google but its actually not. Driving me gaga now.

    Anyone got any ideas?


    Edit: Got a mate to sort it out with Excel 2007 and save as old file type (not .docx). Cant believe there is no work around for this though.


Advertisement