Office Scripts
i have a business microsoft office account and am signed in with it. when i try running a script in excel i keep getting the error saying it requires a work or school account. my microsoft account says the following: your work or school account belongs to your home organisation. what do i need to do to get scripts working.
Conditional formatting cannot be displayed when pasting using the camera method.
When I paste the table into a different area (using the camera method), the formatting for some cells is not properly displayed. These cells have “Conditional Formatting” applied, and their colors change based on their content. When I make changes to the original table, I can see that there is no issue and the colors update correctly. This problem also occurred when I used the table as a “linked image.” Visual Explanation; (The original table is on the left; on the right is the same table pasted using the camera method. Both are in the same file and tab.) When I copy and paste the hidden rows separately (using the camera method again), the conditional formatting appears. In other words, there is no specific issue with the rows where the “formatting styles” cannot be displayed properly: Unfortunately, I didn’t get any results when I tried the “shake” method. When I tried it on a new worksheet, the result remained the same. I also tried the “Repair Office” option, but the problem persists. Could there be a row height limit when copying this type of table using the “camera tool” (when capturing screenshots of conditional formatting) When the total row height in the tables exceeds a certain value, the “conditional formatting” properties of the table I move to another location using the “camera tool” do not display. When I copy 26 rows to another location with each row set to 32.75 units in height, all properties are displayed; however, when I change it to 33 units in height, the formatting starts to break. And this total value (26 × 32.75 = 851) isn’t consistent either. When I try to set individual height values for the cells to reach a total height of 851, the issue isn’t resolved. Sometimes I get proper display when the total height is 777, and sometimes when it’s 661. What do you think is the root cause of this problem I’m facing? How can I solve it? Office Version Information: Ref: https://learn.microsoft.com/tr-tr/answers/questions/5861040/excelde-tabloyu-ba-l-resim-olarak-yap-t-ramama-sor
MS Word and Excel Mail Merge Certificates (advanced)
I need to run a mail merge (using Word and Excel) for certificates where per Course each student has a unique number of competencies they have achieved, example code attached. I cant manipulate or add data to the excel content with additional columns. I need one certificate per student each with their related competency achievement(s). Has anyone else found a solution without having to use an add in? Ive seen a template where the creator used the "next if" rule and the "if" condition is if the student ID is equal to, but i cant recreate it.
Export mixed text and tabular Excel to PDF
I have a sheet that I need to export from Excel to PDF. The sheet contains text and tabular data. Ideally, I'd like large bold text to export as heading tags, text as paragraph tags, and the tabular data as a table. Currently, any group of cells containing data that are surrounded with blank cells export as a table, even if they don't contain what a human would consider tabular data. I haven't selected the tabular data and chosen Import > Table. I'm not sure if that would help or not. How can I export mixed text and tabular data from Excel and have it be tagged as desired in the resulting PDF?Why are documents now displaying tiny cells and none of my cell text is visible.
Opened this application today to find this. The view is damaged or corrupted so that there are hundreds or thousands of cells visible in the viewport at 100% view scale. Zooming in does nothing to improve this. Zooming out to 10% then appears to show some of the text very small in the top left of the viewport, until zoomed in again at which point the text disappears once more. What is visible is very clear in the screenshots attached to this post. We have attempted an online repair of microsoft 365. this has done nothing. All existing documents persist in showing this. All new documents persist in showing this. We do not know what windows updates have been done. Nothing has been done by us. We do not know if any changes to drivers has occurred. Nothing has been done by us. We are looking for advice or knowledge from any user/s who have seen this specific issue before.
Delete a print area label on a worksheet
Hi, I would like to delete the print area labels on a worksheet. I find that the labels I used are not descriptive enough. Excel names the first print area as Print_Area. The next area would be labeled Print_Area_1. I would like to delete all of the labels or perhaps selected labels so I can enter a label name such as Print_Area_1_SUN. Would appreciate your help with this. Joe
