Hello Angelo

Thank you for reaching out to us.

Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

You can write credentials here just check PRIVATE Reply so nobody can see them except us.

Hello again Angelo

I really can't say without taking a look. Can you send me the file you're trying to use, so I can test it locally?

If it works on my end, I will need either a clone of your website, or wp-admin access, as we don't provide live support, so screen-sharing sessions are not included in the provided support for the plugin.

Remember this is a public ticket, so make sure to enable the PRIVATE response if you're sharing anything with me.

I'm glad to hear that, Angelo.

Please let me know if you have any further questions or issues.

Hi Angelo

When working with Excel-based tables, please note:

1. Formulas and merged cells are not supported,
2. They generally work slower than CSV files, or even Google Spreadsheets; so if your table is large, it is much better to port it to a different format, or – even better – to MySQL table (you can use “Create a table by importing data from data source” to import your Excel file to MySQL).
3. Formatting applied in the original file (font families, color, size, fill color, etc.) will not be copied over to the wpDataTable, but you can make whatever adjustment you may need in WpDataTables.
4. Tables linked to an existing Excel file are not editable, nor are they saved in the database.
5. Generated tables cannot be replaced with another Excel file. Each new file has to be a new wpDataTable.

Only raw data from an Excel file can be included in wpDataTables.

Hi again Angelo

Formulas cannot be imported from Excel or Google Spreadsheets in wpDataTables. You are, however, able to create calculations with basic mathematical operations using Formula Columns. Basically, you would need to create an Excel file without the formula column, add it to wpDataTables, and then add a formula column.

Importing images and custom shapes is also not supported, you can only use raw data (letters, symbols and numbers).

If you create a table linked to an Excel file, the plugin will add the source file in ../wp-content/uploads/YEAR/MONTH/ folder, so if you want to change the data of the source file, you need to do it in there.

Please note: Once you create a table from an Excel file, changes in this file, like:

• Changing the column’s name,
• Changing the column’s order,
• Deleting the column, and
• Adding a new column.

are highly not recommended, because the table in the wpDataTable plugin will not work, at the moment. If you make any of these changes, please recreate the table again.

You can create charts from wpDataTables, but please go through the documentation, to see which rules they follow.