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
84 Replies
- Thys1Occasional Reader
Good day
Is it possible to ask a question and include a excel sheet, I have never used the community before.
- patloomyCopper Contributor
Good Morning All,
I know this is probably a very simple question - but the gerbils are not running at 100% yet. I have multiple spreadsheets - let's call it 4 separate tabs of company information by type of company, what I am wondering instead of having to jump from one tab to the other tab. Having a Single page with ALL names listed or simply using the FIND option to drive you to that name?? Hope that made sense, as some of these tabs have 20-30 names and a whole host of information, so scrolling up-down is silly.
- SnowMan55Bronze Contributor
Yes, that might be handled with a single formula on your Single worksheet. It might be handled like this (depending on your version of Excel, which you should mention when posting):
=SORT( VSTACK( 'Company Type 1'!A2:.A999, 'Company Type 2'!A2:.A999, 'Company Type 3'!A2:.A999, 'Company Type 4'!A2:.A999 ) )
Naturally, you would use your worksheet names, and change the column letter from A to whichever column contains the company names (it can be different for each worksheet). And by using a "higher" letter right after the colons, you can retrieve multiple columns at once. VSTACK info The periods immediately after the colons reduce the ranges to however many rows contain data, as described here; just remove them if your Excel version does not support that.In the future, please do not add your question/issue/problem to the end of an unrelated post such as this. Instead, click the big blue "Start a Discussion" button near the top of the main page to start your own message thread.
- luiscarlosgCopper Contributor
Hola a todos,
Tengo problemas con un documento que se trabaja en colaboración, resulta que ya hace varias semanas se está perdiendo información y ahora ya incluso no aparece en el historial de versiones, trabajamos 3 personas en el documento llenando registros con datos como servicios, vuelos, coordinaciones, pagos, etc. pero, al momento de ingresar la información, ver que todo está bien, el internet, el control de autoguardado, cerramos y al volver ya no hay datos, algún comentario o solución por favor
- 7086255123Copper Contributor
Hello, we are having issues on an excel file that results corrupted or damaged. This file is very important for my company. I post the screenshot of the error hoping that somebody can help me to solve this problem.
- mohnoorCopper Contributor
I'm having trouble linking workbooks in Excel Online on my Outlook account (email address removed for privacy reasons, Premium subscription).
When I try to link cells between two sheets in my OneDrive account, I always get a "Server Error" message. This works fine on another Outlook account, so the issue is specific to that account.
I've already tried signing out, clearing the cache, using different browsers, and making sure both files are mine and available in Excel for the web, but to no avail.
Can you figure out why the link isn't working and help me fix it?
- mohnoorCopper Contributor
Issue with Workbook Links Causing "Server Error" on My Outlook Account
Dear Microsoft Support,
I am having an issue with workbook links in Excel Online using my personal Outlook account
:
email address removed for privacy reasons (premium subscription, renewed two days ago).Whenever I try to create references between two Excel sheets—both owned by me and saved under the same OneDrive account—I get a "Server Error" message. The links do not work and data does not update. This works fine with a different Outlook account, so the problem is specific to this one.
I have tried:
Signing out and back in multiple times
Clearing browser cache
Using different browsers and devices
Ensuring both files are owned by the same account and opened in Excel for the web
The issue persists, forcing me to copy data manually every hour.
Can you:
Investigate why workbook linking fails on this account?
Confirm if there are known limitations or bugs for this feature?
Provide a resolution or workaround?
Thank you.
Best regards,
Dr. Mohamed Nour - mohnoorCopper Contributor
The linking between Excel sheets is unavailable. I paid for the subscription, but this linking is unavailable and the same problem is recurring on the server.
This is specific to the account I'm talking to you from. (mailto:email address removed for privacy reasons)
It's a subscription account.
I have another, unpaid, old account. The linking service works fairly on it. Why? And what is the solution? - Shiva143Copper Contributor
please help me about my excel misbehaving issue because of that we are unable to do our work please its a urgent
- marco_sin_sCopper Contributor
Al querer vincular dos libros de excel recibo un error de servidor y las celdas no se actualizan.
Todos los vinculos son confiables y esta puesta la actualizacion automatica.
- Shiva143Copper Contributor
Excel misbehaving and interrupted editing , copy and paste Inconsistent cursor movement (unexpectedly jumping up/down) disrupts data entry and editing.
- Shiva143Copper Contributor
please help me about my issue excel is misbehaving because of that issue our work is hampered please its a genuine issue if you want i can share a video with you its excel bugs please resolve the issue i did all the troubleshoot but i have not any solution and your support team already said we just provide basic support for advance support raise a request on Microsoft Forums