convert tables to range

  1. N

    Trying to cleanup many individual, macro-enabled workbooks with tables to rollup data with Power BI

    Hello, I have a data analysis project to roll up multiple individual, macro-enabled Excel workbooks with tables and formulas. Each workbook contains 31 individual sheets (one for each day of the month). The 31 individual day worksheets each contain nested Excel tables with formulas and are...
    • npasha1
    • Thread
    • convert tables to range copy paste as values delete sheets macro password protected power bi roll-up save & close
    • Replies: 0
    • Forum: Excel Questions
  2. R

    how to convert raw data to convert table

    S.No Name &Designation From to days Basic Pay Due DA%-38.776 Drawn DA%-33.536 Differ GPF (or) (10% PRAN) 90 % CPS Cash Reamrk NEED THIS TABLE COLUMN Q TO COMUN AG CELL FORMULAS IN EXCEL 2007 ( ALL 3 TABLES) SOME ROWS ARE DIFFERENT 1 K.NAGAKUMARI 01-07-2019...
  3. P

    Problem sharing workbook

    I am having problems trying to "share workbook" every time i do it pops up 'This workbook can not be shared because it contains Excel tables or XML maps. To share this workbook, convert the table ranges and remove the XML maps.' i have converted the tables to range and i have looked into the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top