Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.
Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi AliGW,
I don't know why, but I'm not able to attach this file.
I try to sent a link: https: // 1drv.ms/x/s!AoFvbNZ--3FKo6heRSuQ7pf3wshT0g <— this is my spreadsheet with the problem!
(just copy the 1drv.ms/x/s!AoFvbNZ--3FKo6heRSuQ7pf3wshT0g and paste to a URL browser)
porra.png
Thank you!
Last edited by leonelcd; 12-12-2018 at 02:27 AM.
You cannot post links until you have made at least 10 posts, which is why I bothered to give you instructions about attaching a file which you have not bothered to read and follow ... Try again, but read my instructions first.
Hi AliGW,
Ok. For while, I try to sent a link: https: // 1drv.ms/x/s!AoFvbNZ--3FKo6heRSuQ7pf3wshT0g <— this is my spreadsheet with the problem!
(just copy the 1drv.ms/x/s!AoFvbNZ--3FKo6heRSuQ7pf3wshT0g and paste to a URL browser)
Thanks!!
Please take a moment to read our forum rules:
I will provide a link for you this time: https://www.mrexcel.com/forum/excel-...reference.html3. Questions that are cross-posted to other web forums must contain links to those posts on those forums or a comment to tell us where else the question has been asked. (A, Z*)
I will not help you until you attach the workbook using the instructions I gave you in post #2. I and many others here will not (and should not have to) follow external links in order to be able to help you. I am not impressed that you continue to ignore the instructions I gave: it does not bode well.
Unfortunately, I have now run out of time. You will have to wait until someone else is free and willing to help. In the meantime, please get your file attached here using the instructions in post #2.
Last edited by AliGW; 12-12-2018 at 02:35 AM.
Hi AliGW!
When I click in "Go Advanced" and the "Attachments", see what I get:
c.png
What I have to do??
Thank you!
With this post I reach "10" posts =)
... but I still can't make a attachment =/
Any suggestions?
d.png
How about actually READING the instructions I gave? Here they are again:
Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Hi AliGW!
I saw the Manage Attachments, but there is another problem for me: the file size limit! My file with the problem has 15 mb and and the limit is 10 mb =/
Any suggestions?
Cut it down! We don't need to see the entire file - just a sample file that is showing the error messages.
It seems to me that you have had this workbook crash and then Excel has tried to repair it. Have you looked at the repair log? What does it tell you? Have you checked that the items reported as missing really are missing?
Hi AliGW!
I can't cut it down without saving and lose the error. About log error, it's that. It's possible to save me?rs
Hi AliGW!
I can't cut it down without saving and lose the error. About log error, it's that. It's possible to save me?rs
?xml version="1.0" encoding="ISO-8859-1"?>
recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
logFileName>error152960_01.xml</logFileName>
summary>Errors were detected in file 'C:\Users\leonel.ferreira\Desktop\[calc] SAMSUNG – Cálculo Diferencial de Alíquota PIS_Cofins (Março a Novembro 2018).xlsb'</summary>
removedFeatures>
removedFeature>Removed Feature: External formula reference from /xl/workbook.bin part (Workbook)</removedFeature>
removedFeature>Removed Feature: External formula reference from /xl/styles.bin part (Styles)</removedFeature>
/removedFeatures>
/recoveryLog>
So if saving gets rid of the error, what exactly is the problem? If the workbook is corrupted, I suggest you go back to the last version of it that you know was working. I am sure you have back-up files.
It's really driving me crazy, because a rebuild the worksheet about three times!!!
Hi AliGW!
I tried backup files. I tried rebuild the worksheet. I tried search on internet about this problem, but nothing.
If I save the file, the error message is gone, but remains the worksheet losing my tables, formulas and format at all.
I don't know what to do =(
Neither do I - sorry. If you have no backup files that work, then you will have to rebuild what you have lost and put it down to experience.
I already tried backup files which point is before what I need to get. When I go further with calculations and other things, in some point, because reason that I don't understand, the worksheet break up and get the error.
Is there a way to upload my file even with 12 mb? I don't know how to reduce more.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks