WebDec 1, 2024 · Follow the steps given below to find a perfect solution: Go to File and then choose Save As option. Choosing the Save As option will let you save the file on your local disk. Once the file is saved on your local drive, your file will be error-free. For further satisfaction, you can check the pivot table if the Data source reference isn’t ... WebTriệu chứng. Khi mở sổ làm việc Excel chứa dấu ngoặc vuông trong tên (ví dụ: "foo [1]"), người dùng sẽ nhận được thông báo lỗi sau đây khi cố gắng tạo pivottable bằng cách dùng dữ liệu từ bên trong sổ làm việc:tham chiếu nguồn dữ liệu không hợp lệ
How to Find and Fix Excel Pivot Table Source Data - Contextures Excel Tips
WebSep 16, 2024 · Follow the steps to do so: Close the Excel window currently using the file.Now utilize File Explorer to locate the Excel file location > and as you go there> right-click on it > select Rename. And remove brackets from the file name and try recreating the Pivot table again. WebI found the reason the pivot tables didn't work was because of the file name. The reports are generated by a report automation system and the name contains square brackets [] … rbn fashion
How to Change Data Source Reference for a Pivot Table in Excel …
WebIf so, try changing the file name and then create a pivot table. If this is not your scenario, to help us understand your scenario better, we would like to confirm the following information: 1.A screenshot of the Excel version you are currently running on. 2.The detailed steps that you took to create the pivot table. Regards, Alex Chen. WebAfter you create a PivotTable, you can change the range of its source data. For example, you can expand the source data to include more rows of data. However, if the source data has been changed … WebA couple of options: add garbage column headings to columns C&D then select the whole range, ignore the junk columns. Put the two lists into tables (highlight the cells, insert tab, table). Then click the data tab, click the "add to data model" button. You can then create a Power Pivot table from the two sources. rbn foc