enter data

  1. D

    Pivot with extended table for manual input.

    Hi everyone, I would like to ask on how to make extra rows on a pivot table?. I've seen this one excel file which there is a Pivot table and on its right side there's an extra rows that you can enter data on it. It looks like a part of Pivot table but right clicking on its cells and headers...
  2. G

    Wait till data refresh?

    Mr excel team and all users thank you for the support and abundant knowledge transfer. :) Any better ideas ? This is Workbook A (name keeps changing) I got a number 404 in P1. (total 404,504,604... 40 numbers) Once i change the number data is updated in all sheets. Then user click Ctlr+Q to...
    • GSBR88
    • Thread
    • data refresh enter data link update macro refresh data
    • Replies: 0
    • Forum: Excel Questions
  3. G

    Gabriel

    I have created a sheet for entering data into some cells by useres. I want to protect the whole sheet to keep all formats (colors, validations, etc.) on the sheet. I want to enable only the entering data without any other modify of cells. The problem is if I lock a cell the user can not enter...

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