I have a problem with sheets and charts. When I import .xlsx file, add sheets with charts (have to detach on each sheet charts), save, close and reopen .qvw every chart is on it's default values and I have to do it again. I'v tried to go to properties of chart, taba Expresssions and in Definition type detach, but then I just get chart with default values.
Does anyone know how can I save my charts in sheets without changing to default (I'v tried with bookmarks)?
When you make selections and then 'save' a qvw, your selections should remain when it's reopened again, that's default behaviour. You should check that there are no Document Triggers that clear selection, either on opening the document OR sheet selection.