Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
6 years ago

copy tab with Quick View and keep the connection

Originally posted by Mike Turbes

How can I copy a tab in Excel that includes 1 or more Quick views to a new tab or to another file?

Thanks,

Mike

3 Replies

  • OSAdmin's avatar
    OSAdmin
    Valued Contributor II
    Originally posted by Mike Dewis

    Hi Mike,

     

    I think you can copy to other sheets in the same workbook but not to another file.  There is a function in the OneStream XF menu under Quick Views called 'Create Copy of Selected Quickview'.  If you enter another sheetname and cell reference, it will copy the Quickview.  This will be a new quickview which you can see referenced in the Excel Name Manager under Formulas. 

    Hope this helps.

    Mike

  • fornariale's avatar
    fornariale
    New Contributor

    Hi, i have the same problem but seems that I can copy from tab1 to new existing tab2 only 1 QV by time and not all the QVs on tab1. Is there any options that allow me to copy all QV's to a new tab, a sort of create a copy tab at the end of the spreadsheet mainteining all QV's ad pov ?

    Thanks

    Ale

  • RT's avatar
    RT
    New Contributor II

    Any comments from OneStream?