limitations

  1. auto.pilot

    Limitations of Access?

    I have never used access, but just started to investigate the limitations for a potential project. My data sets will have approximately 13 million fields quarterly, and I will eventually need 60 quarters worth of data. That's around 260 million data points. Nearest I can figure, it's about...
  2. S

    Combinations with Limitations.

    So I have a really tough issue that I can't seem to wrap my head around. I have a list of players in each position QB, RB, WR, and TE. I need to pick 1 QB, 2 RBs, 3 WRs, and 1 TE from these lists, I would assume by using combinations. On top of this I want to be able to then limit the...
  3. T

    Excel 2010 - Use a Button on each row to send e-mail with string of data from row - help wanted!

    Team, I am using excel as a checkbook and would like to be able to Create a function e-mail button - specific to each row line item Assign an e-mail action to the button when clicked Once the button is clicked - it pastes the word "Closed" into a specific cell P7:P375 - pending which row is...
  4. K

    Excel 2013 PIVOT Limitations

    Can anyone please help. Our company is in the process of moving over from Excel 2007 to 2013. In Excel 2007 it was possible to have a maximum of 65,534 items in a pivot field before the software would apply a cut-off and display a limited list of items. I have noticed that in Excel 2013 when...
  5. N

    256 char limitiations on functions

    this is a copy of a previous post on summing a text string. Example: 21+12+13..... The string is of variable length with the possibility of 256 or more chars. Try Jindon's Function SumInCell(ByVal txt As String) As Double SumInCell = Evaluate(Replace(Application.Trim(txt), ",", "+")) End...
  6. E

    PowerPivot Size Limitations

    I stumbled upon this post while trying to figure out the size limits of PowerPivot. http://www.mrexcel.com/forum/showthread.php?t=447852 I have a text file, delimited by a "|" (pipe), which has 22 columns and a little under 30 millions row. The text file is about 4.5 GB is size. I started...

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