kvmmoving.blogg.se - Excel for mac 3d maps

Once you get there, right-click on it and choose Rename. Use File Explorer to navigate to the location of the Excel file.If the file is in use, you won’t be able to rename it. Close the Excel window that is currently using the file.xlsx file to remove the forbidden characters. If this scenario is applicable to your current situation, you will be able to resolve the issue by modifying the name of the. If the reports are generated by a report automation system and the name contains forbidden characters like square brackets ‘ ‘, you’ll get this error message whenever you try to create a PivotTable. One of the most popular reasons that will end up triggering the Data source reference is not valid error is an incorrect Excel file name. Method 1: Removing brackets from the file name You should eventually stumble upon a fix that will be effective in your particular scenario. Below you’ll find a collection of methods that other users in a similar situation have used to get this resolved.įor the best results, follow the methods in the order that they are presented.

If you’re currently struggling to resolve the Data source reference is not valid error, this article will provide you with several troubleshooting steps that will help you identify the problem that is triggering the error message. In this case, you can use the Name Manager to identify the values referenced and make the necessary modifications to resolve the issue.

The data source refers to a named range that contains invalid references – Another possible reason why this error occurs is when the range is defined but it references to invalid values.

In this case, you can resolve the issue by defining the rage before attempting to create the PivotTable. If you’re trying to create a Pivot table with a range that wasn’t defined, you’ll be by the same error message.

The pivot table data refers to a non-existent range – A range that is not defined properly can also be causing this particular error.

If this scenario is applicable, you can resolve the issue by saving the. In this case, the file will be opened from a temporary folder, which doesn’t have the same permissions as a regular folder.

Excel file is not saved on the local drive – You might be seeing this particular error message if you attempt to create a Pivot Table from an Excel file opened directly from a website or an email attachment.

In this case, the issue can be resolved by editing the file name and removing the square brackets. One popular reason why you might be seeing this particular error is if the excel file name contains ‘’.

Excel file name contains square brackets – There are a set of forbidden characters that are not supported by Pivot tables.