User Profile
Modula
Brass Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Re: What causes an excel file to 'Show Print Preview' rather than show the preview by default.
I've figured out what was causing it. I did play around with clearing cell formatting and using inquire etc aswell, as to your suggestion. The document was only about 7 pages to start, but after that I decided to start coping elements over to another blank excel file until it would reproduce the 'Show Print Preview' issue on that file, and I found what was causing it. I suspect that the person who made this document, converted their table from another format, as all the cell lines, even though they adhered to formatting, also had shape lines drawn on them, they were hiding across the whole doument, but I didn't see them until I started copying it over to the other document. I had to Press F5 - > select Special, - > Objects, - > OK and press delete to clear the whole document of these shapes This meant the show print preview button cleared and the preview went back to normal, and now the document runs through the flow correctly! I suspect that the excel render engine gets overloaded perhaps with too many shapes, and the conversion tool might rely on the that part to be working to convert the document to PDF, but at least we found the solution, which means the Power Automate OneDrive convert file does not keep failing with error 429 "Alert: Your operation has been throttled." from it retrying to convert the file so many times that it gets shut down. Thanks for your helpWhat causes an excel file to 'Show Print Preview' rather than show the preview by default.
I am curious what causes this to happen, I have already set the print area etc., but for some reason I don't get an immediate preview when going to print, I have to click this button inside the print preview. (I have also attached the full screenshot Doesn't seem to matter what settings I change so far, just curious what exactly causes this change in excel, I have many other documents that just bring up the preview straight away when going to print, but at the moment, this one particular file I have to click another button. I have a MS flow that converts excel files to pdf automatically after a review process, but it keeps failing on this one file and I can't figure out why, but I think the key revolves around this, so I really want to find out what causes excel to present an additional button that you have to click to generate a preview rather than showing the preview off the bat like it does with every other file which works fine in the flow. ThankyouSharePoint lists and document quick part issues.
Within our SharePoint site, we've organized a collection of documents alongside several lists, each linked to lookup columns within the Documents folder. These lookup columns, in turn, correspond to quick parts embedded within the documents' footers, generating a unique document code derived from about three dropdown selections. However, an inexplicable issue arises intermittently, primarily during the initial stages of document creation: these quick parts within the documents often malfunction, failing to display their correct values. What was once a clear selection like "ABC" from the dropdown might inexplicably revert to showing its respective row number from the SharePoint list such as "1". The below examples shows a correct list with one that is no longer working correctly. - Strangely, while users may create multiple documents without encountering any problems, the next document they generate suddenly exhibits this bug, despite following the exact same procedures. The only known resolution is to delete the affected document. However, even when creating a new document, using the same name as the previous one triggers the same issue immediately. To avoid this, it's necessary to ensure each new document has a unique name. This persistent issue has gone on for almost two years, causing significant inconvenience. It doesn't discriminate between files generated from a SharePoint template or those directly dropped in from desktop. None of the files are old versions of word, the problem can arise randomly with a document at any time. Notably, none of the users have OneDrive synced to this site; all operations are conducted directly within the SharePoint site, which operates with major, minor, and draft versions. Furthermore, it's worth noting that the bug tends to manifest primarily during the initial stages of document creation. Once the document is initially set up with the correct values, subsequent issues are relatively rare. When quick parts fail, the documents row in SharePoint still shows the correct values for each of the columns for the drop downs, i.e ABC DEF HIJ. However, despite this, the document footer still displays numbers 1-2-3 instead of the correct letter values. I have spent some time trying to figure out an explanation. Can this still only be summed up as some sporadic SharePoint bug?Re: Word file quick parts don't match correctly to SharePoint lists just shows numbers
I am able to create new documents and rename them or change their codes without encountering any issues. I can even duplicate data from documents with broken quickparts into unnamed documents and have functional quick parts in these documents with the same text data. However, after deleting the original document and renaming the new document with the same name to replace the old one thinking its fixed, the quick parts in the new document stop working. This makes me suspect that SharePoint is altering the document based on cached information that I am unable to locate. Although most documents are unaffected, this issue seems to occur at random. Again if I replace a broken quick part document with a working one and redo it from scratch, the quick parts are fine initially, but as soon as I rename the new file with the file name of the previously deleted one with the quick part issue, the new file becomes broken as well. This occurs even though I may be the only one accessing the files and no automation processes are involved, these files just have text and maybe a table or some images, they are not complex or even large. The only solution seems to be when this issue occurs is to create a new duplicate document from scratch and give it a different name. Although this interferes with our indexing and naming system. Reinserting a quick part from the fields section doesn't fix it either. Surely there is a better fix or a way to resolve this properly.Word file quick parts don't match correctly to SharePoint lists just shows numbers
I am using quick parts to track documents based on drop down values. I have a template in the SharePoint directory that is used when new documents are created. Recently, I've encountered an issue where, after creating a new document and selecting values from the Quick Part drop-downs, the document saves correctly. However, when I later open the file from SharePoint, even though it is in the same directory, I notice that the Quick Part drop-downs have changed from their initial letter values to a number. This number appears to represent the position of the original value in its corresponding list. However, the drop-downs no longer connect to the list and only display the tag name without any values. Here is an example of a file with quick parts that works correctly, the end normally has an index number, but the first two quick parts are meant to have 3 letter abbreviations. Here is an example of the issue that is occurring Can't figure out what might be causing this, even if I don't use the same template, or try to reconnec the quick parts it still has issues once it happens to any document.Comment Tags notifying other non-associated members as well
Some of our staff periodically get notification emails of comments left on particular documents in SharePoint randomly. e.g You comment tag person2 but person3 also gets a message about it, even though they don't have anything to do with the document. At the moment it seems to only be affecting one particular member enough that they email me about it every time, they don't want it, happens every other day. I've read something about turning off One Drive or SharePoint page notifications but they still need notifications for when they're tagged in documents, it says they're batched separately however they don't have independent toggles. Other places say or show @mentions as separate to comments, but has that since changed? Support page demo below I'm sure its just that they're subscribed or following changes on a document or something like that, but I can't figure it out.100s of folders on desktop outlook, not on web, how to migrate or sync
A member of ours has made 100s of folders for unique projects and email conversations in outlook on their desktop, all under one email account. They have recently upgraded their machine and can't seem to migrate the folders easily. The folders are not on their web outlook, so when they log in on their other machine, either via desktop or web they don't see all the content they do on their original machine's desktop outlook, none of the organised folders have migrated or sync'd. Is there an easy way to get all these folders into the cloud or web outlook without having to recreate each one? Migrating the outlook local data files wouldn't really be a fix, if they login elsewhere outlook needs to show those folders from the web or cloud, if you make a folder in web it's on the desktop outlook in seconds, yet none of their desktop outlook client folders populate web.Version and UIVersionString Label are not always the same
I recently setup the manual UIVersionString Label so that the version of documents can be shown inside a document file from a SharePoint library. However I have found despite doing this, the label doesn't always show the correct version and is sometimes a couple of versions behind. What can cause this?Re: Sharepoint Numbering Column won't let me have 001 or 012, it won't let me start with 0
I tried to use this inside conditional formatting for the text index column, it saves fine but then when I go to see the conditional formatting its blank again, like its not applying =AND(LEN(Column)=3;ISNUMBER(Column+0)) I find that if I set the index number inside the SharePoint library by editing the columns, it actually holds the 3 digit number fine, such as 001 or 002, but if I use the document quick parts label to enter the number while in the document, that's when it registers as 1.00000 or 2.0000 inside in SharePoint. Not sure what is going onSharepoint Numbering Column won't let me have 001 or 012, it won't let me start with 0
Is there a way to set a SharePoint number column to allow numbers that start with 0? We're setting up an index system and for some reason it always removes the 0 and there doesn't seem to be a way to have it not do that. I also tried to use a text row instead, but even that converts 001 to 1.0000000Re: Using Lookups with additional columns for document quick part labels
I experimented with this however as many people use the library at the same time the automation kept failing, as members would have the documents open at the same time and it wouldn't work. In the end I just changed the tile of each lookup to represent the alpha code abbreviation. Everyone has to reference it manually if they are unsure now I don't see much use for the additional table option for SharePoint looks ups other than being able to see it on the main list if you'd like. Quite frustrating, seems half baked.Using Lookups with additional columns for document quick part labels
When you setup lookup columns inside SharePoint you can choose to show additional source columns from the lookup list. However when you setup a word document and load the quick part document property labels, it only shows the first column associated with the look up, despite the library the file is in showing all columns. Is there anyway around this yet without changing the identifying column of the lookup? I want to make a unique code at the document footer that goes something like, APL-IFT-PCD Which comes from 3 lists, company, department document. Each list has an abbreviation alpha 3 code. I.e company Apple is APL. Even though the document library shows both columns using the show additional columns from the lookup list, inside the word document quick parts it only shows the first column Apple which defeats the purpose. Thankyou
