Forum Widgets
Latest Discussions
Error Opening the Excel
I can't open the file Get Message. Saved in Last time. Previous Version history Not available. Copy from Cloud to pen drive no difference. Try in 365 online mode not open. Try with google sheet not Open. Change the file extension to .xls & .csv not open. Online Platforms not open. Change the Computer and Operating System. Try to open WPS; But no change.
SPILL error
Hi. I'm just using a very simple formula to calculate how much money is still due from an original total amount. The formula I have typed is simply in this format: 6000 -(B2-B8), but in the next again cell where I am looking to display the result, I am getting a SPILL error. The correct total is displayed in the cell, but a number of cells immediately below are displaying the "6000" figure!! I'm struggling to correct this - can you help :-) Thank you 👍Complex formulae with data model
Over the years, I have developed a significant excel data sheet which has gotten slower and slower with time. I have discovered the idea of excel's data model this week and have learnt how to import the data I need from its source CSV to the data model and I now have a power pivot which looks like what I originally had in excel. What I would like to do next, is to replicate some of the formulae I had in excel to calculate if something should be counted or not. I would not want the red one to be counted as this row would have been counted in the previous month. In excel I was using the following formula- =IF(COUNTIF(B5:M4,">0"),SUM(Patient!B5:M5*0),Patient!N5) is there a way of achieving this with the data model or would I have to hardcode this into another sheet? I was trying to avoid doing this to minimise the number of formulae... Many thanks for your help...
Excel formulas starting to include current sheet name
Hi I recently noticed that formulas in excel starting to automatically include the "current" sheet name after leaving and coming back to the sheet (example below). I don't remember this used to be the case but I could be wrong. Does anyone have a similar experience or can confirm if this is correct? Is there a setting somewhere I can turn this on and off? Example: I have 2 tables (1 per sheet). After clicking on Sheet2 to select the cell I want to sum, coming back to Sheet1 and referencing any cells will include "Sheet1!" in my formula. I believe previously the formula omits "Sheet1!". Both ways are useful in different scenarios but wondering if I have missed a trick to "turn on and off" how it behaves. Thanks!
Analysis ToolPak
With respect to the Analysis ToolPak for use to perform the t-Test, if the option for "t-Test: Two-Sample Assuming Unequal Variances" is selected, is the Satterthwaite Approximation used and not the pooled standard error? Refer to the following URL: https://support.microsoft.com/en-us/office/use-the-analysis-toolpak-to-perform-complex-data-analysis-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6 Please advise or provide feedback.Filling a column with succeeding lists
Hi, I need a list of files, with numbers starting from 001 for each box. Adding the number for one box is easy but I have thousands of them. A box number is like "0001AA0001". The first number and the letters never change, so I have : 0001AA0001 0001AA0002 0001AA0003 Then I have to add the files numbers, like "0001AA0001/001". I already have a line for each file, but only with the box number in the forst column, repeated several times, each time for every file. What I have What I need 0001AA0001 0001AA0001/001 0001AA0001 0001AA0001/002 0001AA0001 0001AA0001/003 0001AA0002 0001AA0002/001 0001AA0002 0001AA0002/002 0001AA0003 0001AA0003/001 0001AA0004 0001AA0004/001 0001AA0004 0001AA0004/002 0001AA0004 0001AA0004/003 Can you please tell me how can I add automatically the /001 and so on without having to do it for each box ? I can't manage to use a model for CTRL+E and I'm not accustomed to use the functions. Thanks, M.T.
Latest updated removed all of my Quick Access Toolbar customizations.
Latest updated removed all of my Quick Access Toolbar customizations. It's not hidden - it's there, it's just empty of everything but the default commands. I have checked for a *.qat file in these directories C:\Users\<username>\AppData\Roaming\Microsoft\Office C:\Users\<username>\AppData\Local\Microsoft\Office but there's nothing there. I have never exported it (did not know you could) so there is no *.exportedUI file to use I have around 40 commands and don't even remember all of the correct names to rebuild it.
