Excel couldn't refresh table from connection
Hi guys I have one excel file, then transform into Power Query then move to power pivot to make measures in this before creating pivot table. The file only use table in current file, not including any external source, I just use excel.currentworkbook to refresh the file When I move file to another person, she caught an error saying like this "Excel couldn't refresh table from connection "Query-TongHop1". Here is the message from external data source. The operation failed because the source database does not exist, the source table does not exist or because you don't have access to the data source. More details: - OLE DB or ODBC error: [Data.Format.Error]. Invalid cell value "#VALUE" - An error occur when processing table "TongHop" -The current operation was cancelled because another operation in the transaction failed. I have check but no #VALUE errors. Could you please tell me how to fix this error?Please tell me what I am doing incorrectly-Excel SUBTOTAL Function 9 and 109 return the same Results
A Spreadsheet, created using macOS Numbers, was opened in Excel because it offers a wide range Of Functions, and the ability to Hide Cell Content seemed an ideal choice for the project in hand. So I have commenced a Trial of 365. Applying the following to this Spreadsheet failed to function as expected and so I set up Test01 in Excel. In Test01 selections are made from a Column of Products, in this case, identified as 10 Letters. In the second Column each of these has been given a Value, in this case, they are all 10.00. In Format the Value Column has been set to Number. In Sheet1 Custom has been used the Hide the Values of 3 Letter V Products. In the Total Row =SUBTOTAL(9, B2:B11) returns 100 as the Result. Because on the Working Sheets some Values are required to be Hidden and the Rows contains them are Copied & Pasted to a Second Working Sheet, Test01:Sheet2 was created similarly. In Sheet2 the Total Row =SUBTOTAL(109, B2:B11) returns 100 as the Result. https://1drv.ms/x/s!Au2bj9QvcxAObq50EYUboaxsJz4?e=XH3hC5 Thanks for any help you can offer.
How to make all users in a shared excel anonymous
Hello, I want to make an excel document in order to evaluate people. The problem for ex: lets say people evaluate each other from 1-5. I want to share an excel document with all my colleges, so they can rate each other. I want to keep this anonymous but all of us are logged in Microsoft accounts, so even if its only by the link we can still see who is writing what. The solution I have now is to ask everyone to open the document in a web browser in incognito mode. Is there a way to set all users using the excel document to be anonymous? Thank you for helping! 😄
Linking Excel data to Publisher
I copied CTRL+C data from Excel and pasted Home>Paste>Paste Special/Paste Link in Publisher. It came in as a linked table which I can format at will – all borders / outside borders and I can enter the cells and change e.g. font colour. When I repeated this action with data from the same Excel file, a few rows further down and linking to the same Publisher file – one page later - it came in as a linked object which I can format - outside borders but not all (i.e. inner borders) and I can not enter the cells to change the font colour. I can paste using right-mouse but then the table is not linked. Any ideas on why? To the best of my awareness I haven't done anything differently. Thanks for any insights. DennisExcel Table Autofill using IF() Statement
I'm trying to build a table in Excel that uses IF() statements to apply different formulas to the same cell based on characteristics in a cell at the top of the page, but running into issues as the columns that contain the IF() formulas don't autofill correctly. Example: We have certain billable rates that are pulled from a VLOOKUP based on input from an adjacent column, but if an individual wants to override that billable rate with a flat rate or a broadly applied % discount they enter at the top of the worksheet. I'd like the formula to update to reflect the new numbers, but also autofill when the individual adds a new row. Thanks for the help!Pivot tables - Change Connection not refreshing.
Hi Team, I have a Excel file with 300+ pivot tables connected to SSAS cube. Now I need to change those connection to POWER BI dataset. But The connection gets stuck, showing.... 1. refreshing the cube 2. wating for query execution Finally gives error as... below. PLEASE HELP TO FIXExcel basic IF statement does not work
I have an issue with using the IF function. Originally I wanted to only execute a specific function if todays date was after a certain date. I used =IF(TODAY()>=DATEVALUE("01/03/2022"), SUM(D3;-D8;D9), "") I tried different versions but every time this pop-up appeared: So I figured the statement was probably wrong and I resorted to trying out the basic statement from the manual (=IF(C2="YES",1,2), still the same pop-up appeared. I scoured the net and found that maybe I had to change my regional settings so I did that but it still does not work. Does anyone know why I can't do even the simplest IF statements? I use Microsoft excel for Mac version 16.57
Excel help needed
Below attached is example. There are 2 tables in that sheet. In one table, I have names in one column and places in other. The names are constant but places are updating. And on other Table, I have written the name one time. And I want to have their updated place status from table 1. How can I do that? Please help.
