Forum Discussion
Welcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum.
We look forward to getting to know you!
Sangeeta Mudnal & Olaf Hubel on behalf of the Excel Team
79 Replies
- I'm trying to post a new thread/post for an issue I'm having for Excel. I can't find a link/button to click to create a new thread. Im on a desktop. can someone point in the direction on how to create a new thread/discussion for my question?
hi all,
im new to excel and need help very urgently with my data
I have 2 sets of data open on 2 separate tabs and i must combine them to compare -->through a chart then make a graph, however when i tried to paste data set #1 to data set #2 as a second sheet it does not do anything other than say "pasting in progress" (it has been about an hour) please advise. I followed some basic steps given from a microsoft rep but it also didnt work outSangeeta Mudnal I want to add multiple bullet points in one cell for multiple lines. Since the data is large where I need to do this for more than 1000 cells and every cell contains more than 20 lines. Hence doing manually would be almost impossible. Could not find any solution anywhere.
If anyone can help would be a great support.
That's more chanced to be answered if you Start New Discussion from this https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral page.
- Can someone please help me with my below post/question?
Thanks
Don
Don_Thornton replied to Sangeeta Mudnal
Jun 24 2024 08:07 PM
Hello: How do I receive help with a problem I am having with updating a file with "Stock" data types.
I have a spreadsheet that retrieves historical stock data. The file has over 3000 stock tickers. When I try to refresh the file I receive the following error message. Very few of the cells will update and most state #CALC! in the cell.
The error statement is: "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated."
I have used this function in the past and it has worked but every time I change the date to search by date, which is once every quarter, this message returns and it takes a long time to update the file. Microsoft has helped in the past but now states I need to reach out to this community for help as they cannot diagnosis the problem for me anymore.
Thank you in advance for any help or guidance.
Don Thornton The following formula returns "you have used too many arguments in the formula, where is the mistake that will correct this?
=IF(BJ67>0,IF(BJ68>0,IF(BJ67<BJ68,BJ69,IF(BK67>0,IF(BK68>0,IF(BK67>BK68,BK69,IF(BL67>0,BL68<0,BL69,IF(BM67<0,BM68>0,BM69,IF(BN67<0,BN68<0,BN68<0,BN69,0)))))))
You posted this twice, I moved the other one to a new discussion and replied there.
- Hello: How do I receive help with a problem I am having with updating a file with "Stock" data types.
I have a spreadsheet that retrieves historical stock data. The file has over 3000 stock tickers. When I try to refresh the file I receive the following error message. Very few of the cells will update and most state #CALC! in the cell.
The error statement is: "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated."
I have used this function in the past and it has worked but every time I change the date to search by date, which is once every quarter, this message returns and it takes a long time to update the file. Microsoft has helped in the past but now states I need to reach out to this community for help as they cannot diagnosis the problem for me anymore.
Thank you in advance for any help or guidance.
Don Thornton - Never mind, I found it!
- Hi Sangeeta, I'm new to the Community. I work for the Army as a federal government civilian Operations Research Analyst and use Excel extensively. Our organization uses Excel 365. I am always looking for tips and sometimes next help solving problems using Excel. How do I post a question to the Community, or am is what I'm doing right now the way to do it?
