Do you know what tables store workbook favorites with the specific layout they were saved with by a user? I tried RSRPARAMETRIZA but this is just personal variants not the workbook itself
what I am looking to do is to copy a workbook format to another workbook. We made security changes and we had to create all new workbooks. Users have favorites saved with specific layouts and will be very time consuming for them to recreate. I was hoping to find a table that has the layout defined and try to copy this to the new workbooks. None of these tables seem to have this level of detail.
If I understand correctly, If you want to use the existing workbook template then just do save as and replace the queries which you want in the new workbook.
What I want to do is to take the new version of the query and have it use the old workbook favorites the users have created. I tried to chagne the dataprovider in their workbook to reference the new one but the format is not retained
Please could you explain how did you build the format, I mean you used standard excel functions or Macros.
If you used standard excel formatting functions then it should work or if you are using excel macros may be you need to modify the query name in the Macros.
Please provide more details about the format so that I can help you to provide more points.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.