Basic/Novice Help w/Pasting Protected Data to Another Sheet
Results 1 to 10 of 10

Thread: Basic/Novice Help w/Pasting Protected Data to Another Sheet
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Basic/Novice Help w/Pasting Protected Data to Another Sheet

    I am trying to copy and paste rows from a 18MB .xlsb protected and heavily filtered -- from column N to column EZ.

    I want it to paste into a 998kb .xls file. I can't remove the formatting otherwise certain cells, (based off of dates generated from an external application) -- or It will remove the shaded cells that indicate, no fill, yellow, green, red if dates are forecasted or actualized.

    My issue is somewhere when I copy and paste into the new file. It won't stop calculating and I am creating a file that can't stop linking back to the master file. It is over 398 MB.

    I have tried to paste value and then paste format. I also tried just regular pasting the information into the file.

    The person who showed me this is on vacation and the data is critical/needed by 6am.

    Can someone support my desperate request?

    The folks who are supporting me are not terribly inclusive. It would be so nice to be able to accomplish this, given the woman next to me is taunting me about being an expert just coming into the group?

    Thank you, so much!

  2. #2
    Board Regular mumps's Avatar
    Join Date
    Apr 2012
    Location
    Toronto, Canada
    Posts
    8,162
    Post Thanks / Like
    Mentioned
    87 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Basic/Novice Help w/Pasting Protected Data to Another Sheet

    It sounds like you are doing the copy/paste manually. Before you copy/paste, try setting the calculation mode to "Manual". After pasting, re-set calculation back to "Automatic". Click the "Formulas" tab in the top menu and then click the "Calculations Options" button at the far right.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    New Member
    Join Date
    Mar 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Basic/Novice Help w/Pasting Protected Data to Another Sheet

    I really appreciate your response! I tried that, with no luck

  4. #4
    Board Regular mumps's Avatar
    Join Date
    Apr 2012
    Location
    Toronto, Canada
    Posts
    8,162
    Post Thanks / Like
    Mentioned
    87 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Basic/Novice Help w/Pasting Protected Data to Another Sheet

    Do you mean that even after you set calculation to "Manual", the formulas still calculated?
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  5. #5
    New Member
    Join Date
    Mar 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Basic/Novice Help w/Pasting Protected Data to Another Sheet

    It was set as that to begin with! I pasted first, Values. Then 2nd w/Formatting into the other sheet, and yes, still calculated.

    I have a hidden personal .xlsb folder that appeared during something I botched. I cant get rid of it, even I. Systems Folders. Can this be part of issue?

  6. #6
    Board Regular mumps's Avatar
    Join Date
    Apr 2012
    Location
    Toronto, Canada
    Posts
    8,162
    Post Thanks / Like
    Mentioned
    87 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Basic/Novice Help w/Pasting Protected Data to Another Sheet

    To be honest, I really don't know.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  7. #7
    New Member
    Join Date
    Mar 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Basic/Novice Help w/Pasting Protected Data to Another Sheet

    I'm super grateful for your responses!! I may have some basic V look up questions in a bit… do you mind keeping an eye out if I post under here? Truly you have been a tremendous help, and I hope you have a great day!

  8. #8
    Board Regular mumps's Avatar
    Join Date
    Apr 2012
    Location
    Toronto, Canada
    Posts
    8,162
    Post Thanks / Like
    Mentioned
    87 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Basic/Novice Help w/Pasting Protected Data to Another Sheet

    If your question is on a different topic, according to Forum rules, you should start a new thread. If you send me a private message with a link to your new thread, I'll be happy to have a look.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  9. #9
    New Member
    Join Date
    Mar 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Basic/Novice Help w/Pasting Protected Data to Another Sheet

    Thanks!! I'm brand new here and appreciate the direction

  10. #10
    Board Regular mumps's Avatar
    Join Date
    Apr 2012
    Location
    Toronto, Canada
    Posts
    8,162
    Post Thanks / Like
    Mentioned
    87 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Basic/Novice Help w/Pasting Protected Data to Another Sheet

    My pleasure.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •