Forum

Hi Ann, Can you please upload a sample Excel file showing the issue, it's difficult to visualise your scenario and data layout. Thanks, Mynda

Hmmm, not sure what's going on. What happens if you start a new workbook and a new blank query? I'm wondering if this is a problem with this workbook ...

Hi Alison, You'd need to automate this with VBA. Please post your question in the VBA/Macros forum as this is outside the scope of the Excel Expert...

Hi Leah, I've not heard of that problem before. Can you please send a screenshot of what you see when you click in the formula bar? Mynda

Hi Sue, I should have been clearer, it's not the empty date cells that are the problem, rather that there are some cells that contain values other ...

Hi Sue, You're having problems because your data isn't in a tabular format, so it's difficult to summarise and analyse. First, you need your sta...

Hi Vivian, Thanks for sharing the file. Did you set the privacy settings to 'Public'? File > Options & Settings > Data Source Settings &g...

Hi Nicolas, Unfortunately there's no way to specify a separate colour scale for the negative and positive values. You'd need to do this manually by...

Hi Linda, Workspaces are for collaborating on the building of your reports and dashboards. You can't 'change or touch the data' as such in a worksp...

Hi Rya, In future, please start a new thread for a new dataset. If your question is similar to another then you can reference it in your question. ...

Hi Vivian, Please share your Excel file containing your query with the error. Mynda

Hi Ann, Thanks for sharing your file. I would simply insert PivotCharts with both the actual and budget data in the one Pivot. Then you can use ...

Hi, I normally store my file/folder path in a single column Excel table that contains one row. The Table is called "PathTable" and the column is ca...

Hi Ann, Welcome to our forum! Can you please upload a sample Excel file so I can see what you mean. I'm not sure what you mean by 'list box data...

Hi John, You haven't done all of the steps from the first 'Added Index' step. You've skipped the Merged Queries step etc. Mynda